VBA - Match Cell Value and Paste Specific Cells

Hi All,

I am new enough to VBA,

I have a bit of working code that looks at 2 cell values on sheet 1, and matches them on sheet 2, then copies cell values from sheet 1 and pastes them to that location in sheet 2

Please Login or Register  to view this content.

I want this code to run through the first 100 lines performing the same task for each line, while I could copy and paste this code replacing the necessary cells, this sounds messy and slow.

If anybody knows any tips or tricks to do this faster and simpler, that would be great

Thanks in advance for any replies

Simon

Hi, Thanks for you reply, unfortunately that code doesn't seem to do the trick. It runs without error but I cannot see any changes the code has done

Hi sorry about the delay in the reply, Im not too sure how the break thing works, Im hitting F8 but it just cycles through every line highligthing each one yellow

Ok so after much messing around I have ended up with a final working code, I will post it here for anybody have a similar issue

Please Login or Register  to view this content.

Thanks for the replies