Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP find, copy and paste
Hallo,
I am a very junior user.. so bear with me :O) I need to do the following: * In sheet 1, I have list of names, and in sheet 2 I have the same list of names plus data regarding total revenue generated * In sheet 1 I need to copy the total revenue generated, taking it from sheet 2, through autofill. So it should look for the name match, copy the relevant data on same row, and paste it in sheet 1 I hope this is clear... thanks for your help in advance, S |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP find, copy and paste
Go to Help and read about VLOOKUP
Then come back if you have more questions best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Stef" wrote in message ... Hallo, I am a very junior user.. so bear with me :O) I need to do the following: * In sheet 1, I have list of names, and in sheet 2 I have the same list of names plus data regarding total revenue generated * In sheet 1 I need to copy the total revenue generated, taking it from sheet 2, through autofill. So it should look for the name match, copy the relevant data on same row, and paste it in sheet 1 I hope this is clear... thanks for your help in advance, S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace help with copy paste | Excel Discussion (Misc queries) | |||
Find Copy and Paste | New Users to Excel | |||
Find, copy and paste | Excel Discussion (Misc queries) | |||
Where do I find A bell curve I can copy and paste | Charts and Charting in Excel | |||
Macro to find, copy, and paste until value change | Excel Worksheet Functions |