Copy Data from Columns C and D and Paste below data in Column A and B

[kingsdime29x]

Hello,

I am trying to see if there is a way to automatically find all data in columns C and D and copy the data from those columns and paste in columns A and B below the data in those columns. I would need to be able to do this to multiple worksheets that may not have the same amount of data on each sheet. I have attached my workbook for reference.

An example is that I need to copy data from my first worksheet that range from C3:D21 and then paste that data starting with A22:B22.


Let me know if this is possible. Thank you in advance for your help!

[Mumps1]

Try:

Please Login or Register  to view this content.

[kingsdime29x]

This is perfect! Thank you so much for your help!

[Mumps1]

You are very welcome.