Copy row data from one sheet to another sheet automatically

**chewfoong** · 07-01-2013, 05:32 AM

Hi,

i planned to have the data from one sheet copy to another sheet automatically, i wonder would it possible?
example:
i have a sheet, named it "Master", other few other sheet, named it as user1, user2 and so on
all sheets will have the same headers, when user A entering the data on sheet "user1" row 2, the data will automatically copies to "Master" sheet row 2. same go to User B, when he entering data on sheet "user2" row 2, the data will be copied to "Master" sheet row 3 (since there is data on row 2).

basically, "Master" sheet is to collect all the row data from multiple sheets and combine it.

can anyone please help?

thank you in advance.

**JapanDave** · 07-01-2013, 05:44 AM

You have an issue with doing this. If you want to do this without a button to set off the code, you will have to state which cell will be the final cell that data is entered for an event macro to fire.

**chewfoong** · 07-01-2013, 05:58 AM

Thank for the feedback Dave, if i do that with button, would you able to help me a little bit on the coding part? i just need some starting point and i will modify myself to suit my need.
really appreciate if you able help.

thank you in advance.