Excel import data from another sheet

June 19, 2011 at 23:48:01
Specs: Windows 7, AMD Athlon 3500+ / 528 Mb
I want to import data from another sheet and I want to know who to do that !

Here is a link to my excel file. If you open it you will understand what I'm trying to do .
http://www.2shared.com/document/XMX...


See More: Excel import data from another sheet

Report •

#1
June 22, 2011 at 10:29:45
if i'm reading that corectly,

=IF('sheet 1'!A2=A2,'sheet 1'A2,"")

when you start typing the equation, just write"=IF(" then move to sheet 1 and select the cell you want to compare and it should do all the wierd code for you, hope this helped


Report •

#2
June 22, 2011 at 16:32:55
re: "If you open it you will understand what I'm trying to do "

Not really.

Since you have not provided any "example data" in Sheet2, it's kind of hard to understand what you are doing, especially with Column B.

What do you mean by "print code"?

If I had to guess, I'd say that VLOOKUP might work for you, but since you haven't provided any "output data" in Sheet2, I can't really be sure.

Read up on VLOOKUP in the Excel Help files and see if that will do what you want.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question