PDA

View Full Version : Vlookup or Match? Copying data from one sheet to another.



paddysheeran
02-25-2009, 06:00 AM
Hi All,

another issue im come up against:

I need to build a macro to copy data from the source sheet into the Resolver Sheet so the end result looks like the Completed_Sheet. I cant get my head round wheter I need to use vlookup or match to transfer the data correctly. Can anyone help with this?

many thanks.

Bob Phillips
02-25-2009, 06:32 AM
B6: =Source_Sheet!A3
C6: =IF(ISNA(MATCH(C$5,Source_Sheet!2:2,0)),0,INDEX(Source_Sheet!3:3,MATCH(C$5, Source_Sheet!2:2,0)))
copy across to J6
K6: =SUM(C6:J6)

copy these down

paddysheeran
02-25-2009, 08:02 AM
Hi, thanks fior the response but this doesn't really help with automating the task.

Bob Phillips
02-25-2009, 08:12 AM
Why not?

paddysheeran
02-26-2009, 09:38 AM
Can anyone help with this? I just basically need a piece of code that will look for a value and once found copy all the data below it into the corresponding column in the other sheet.

MaximS
02-26-2009, 05:22 PM
try this, see attached for details.