Copy certain cells from one worksheet to another worksheet with blank rows

Hi,

I am looking for VBA which will copy dates from certain cells in multiple worksheets to one worksheet in multiple rows.

Example) Worksheet "V1" Cell K3 ... to be copied to ... Worksheet "Data" Cell E5 or the next available blank row.

Has anyone got any ideas or code for this?

Thanks!

try this macro (modify to suit you)

Please Login or Register  to view this content.