How to populate data in excel based on column in another excel column sheet

Question

0.00/5 (No votes)

See more:

HI,

I have column A in excel sheet 2 with values ( 1.1, 2.1,3.1,4.1 etc)
i need to display column A in excel sheet 1 with valus 1.1,1.2, 2.1,2.2, etc)

sheet 2 sheet1
  1.1 =  1.1
         1.2

  2.1 =  2.1
         2.2
  3.1 =  3.1
         3.2

c# code would be useful

What I have tried:

I have tried using array list but could not list ,

Posted 19-May-20 4:20am

sham s

Updated 19-May-20 8:08am

Maciej Los

v2

Add a Solution

Comments

Richard MacCutchan 19-May-20 10:26am

"I have tried using array list but could not list ,"
Sorry, that tells us nothing. You need to show the code you have tried, and explain what results you see. Please use the Improve question link above, and update the details.

ZurdoDev 19-May-20 12:12pm

Am I misunderstanding? All you want is for one sheet to match or equal another sheet?

Just put the formula = and then click the other cell. There's no need for code. And if you need code, just record a macro doing what you want it to do and you'll see the code.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Eyssan · Answer 1 · 2020-05-19T06:24:00

Solution 1

use excel formula like:

=Sheet2!A1

However, the question need to be modified and should be provided with attempted code.

Posted 19-May-20 6:24am

Eyssan

Comments

Maciej Los 19-May-20 14:11pm

If i understand OP well, he/she want to lookup for existing value in another sheet. See my answer.

Eyssan 20-May-20 4:47am

May be. The question is not clear.

Maciej Los · Answer 2 · 2020-05-19T08:09:00

Solution 2

You can use VLOOKUP function[^].
See: MS Excel: How to use the VLOOKUP Function (WS)[^]

Posted 19-May-20 8:09am

Maciej Los