Vlookup or Match? Copying data from one sheet to another.

[paddysheeran]

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]

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]

Hi, thanks fior the response but this doesn't really help with automating the task.

[Bob Phillips]

Why not?

[paddysheeran]

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]

try this, see attached for details.