Copy to another workbook with conditions

[samarbac]

Hi Gurus,

I've a very basic knowledge about VBA programming and I'm hoping you will be able to help me. I have attached 2 spreadsheet : 1. Copy From and 2. Copy to

All I want is to copy data from Copy from to Copy to in specific columns. The headers are already there, just need a macro to copy numbers over to another worksheet.

In Copy From sheet there is a title "North" in "T3" - so the section has to be copied in North section in another spreadsheet.

I really hope you experts can help me with this.

Many thanks in advance.

[Eastw00d]

Hi, why not use formulas in stead of copying, like

Please Login or Register  to view this content.

See attachment
Cheers
Erwin

[Eastw00d]

Or use this macro:

Please Login or Register  to view this content.

Cheers
Erwin

[samarbac]

Hi Erwin,

Thank you for the reply.

I'm trying to put this code in the original spreadsheet and it's coming up with an error message "Subscription out of range". I have changed the column/row numbers only.

Please can you guide me the reason for this error.
Many thanks,

Please Login or Register  to view this content.

[Eastw00d]

Hi, that could be anything if you don't tell me at what line this error occurs.
Does it still happens when you replace the last few lines with this:

Please Login or Register  to view this content.

otherwise you have to upload the target workbook.
Cheers
Erwin

[samarbac]

Thanks Erwin
All sorted.
Once again thank you for the help