Macro to copy from one worksheet to another in different workbook

Hello all

A friend has asked me to help on this, I am no good at VBA so wonder if anyone can assist

My friend has multiple workbooks, each containing data. Each worksheet with have the same number of columns but a variable number of rows

Thinking through, what I deduced the simplest thing to do would be this:
Have a macro that would
1.Highlight all the data except the title row in the active workbook
2.Switch to a different workbook called "Consolidation"
3.On the next free row, paste the information

They can then just activate another workbook and run the macro again

Thanks in advance

Here are a few macros that will help you

This code will activate the specified workbook, but it assumes it is already open.

Please Login or Register  to view this content.

This code can open workbooks

Please Login or Register  to view this content.

This code will select the last contiguous record in a column, then select the one right below it (next empty row)

Please Login or Register  to view this content.

As far as running the macro from a different workbook, thats not going to work. Tell me more about the files you are working with, are the names consistent?

Hi Gaiden and thank you

Unfortunatly the workbooks will have different names, and those names will change

That is why I was thinking of a macro that would copy all the data from the active worksheet, switch to the "consolidated" workbook, then paste the information starting at the next free line