Posting rows to new sheet macro

[jay-excel]

Hello,
I was wondering if it were possible to create a macro that when a button is pushed, data is taken from one sheet and copied into another.

I have 7 people in the office that all need to contribute data to an excel sheet. Generally I do this by asking each member to send me their workbooks and I copy and paste the information in manually.

I am trying to create a button that will submit the information into the new sheet.

The data will appear in the same order from the user sheet to the master document.

Any suggestions/links as to where I could reference such code?

Thanks,

 

[okiedokiedoo]

Looking for the same answer. Anyone?

 

[ColinKJ]

Hi jay-excel,

Can you post an example of your data, i.e one from the master, and one from a contributor.

Regards

ColinKJ