Conditional Copying of Specific Cells to a different Sheet

[meme405]

I have an extensive worksheet (about 1700 lines), I want to create a macro that looks at the first column in my 2nd sheet if that column says 'Yes', I want it to copy about 5 cells in that row (say D, E, J and L) and paste them in certain cells in my 1st sheet. The thing is it has to paste them in the first empty row available in sheet 1 and it has to paste the data in different columns (say, B, D, F and K).

I made a macro that would copy certain cells based on the first cell being 'yes' but it would paste them in in the first row of my 1st sheet and it would paste them in the first three columns.

PS, I am new around here. Just graduated from college and started working, before this i was dealing more with macros that simply did complicated calculations. So doing this kind of work is new to me.

Thanks guys.

[HaHoBe]

Hi, meme405,

this code should give you a start-up:

Please Login or Register  to view this content.

Ciao,
Holger