VB Copy & Paste From Array of Sheets

[hobbiton73]

Hi, I wonder whether someone could help me please.

I'm using the code below to copy data from two 'Source' sheets to one 'Destination'.

Please Login or Register  to view this content.

The code does copy and paste the correct inofrmation, but the problem I have is that the data from the latter sheet i.e. "IDEAS Actuals" overwrites the data from the "IDEAS Forecast" sheet.

Could someone perhaps tell me please how I would be able to change this so the data is copied underneath each other.

Many thanks and kind regards

Chris

[patel45]

Please Login or Register  to view this content.

[hobbiton73]

Hi @patel45, thank you for taking the time to reply to my post with the amendment to my code.

It works perfectly, thank you very much.

All the best and kind regards

Chris