Clear contents then paste from subsheets macro [Closed]

Report
Posts
1
Registration date
Thursday November 13, 2014
Status
Member
Last seen
November 13, 2014
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi everybody,

I have 13 subsheets that need to have their data put onto a master sheet. The header in A1:M1 is the same in every sheet, the data below though is always changing. What I need is to be able to clear the contents of everything below A1:M1 on the master sheet then paste all of the data from every subsheet onto it. There isn't a defined maximum number of rows on any sheet.

Or.

The more complicated way...if it's possible it would be great if everytime one of the subsheets is updated it automatically updates the master sheet. This workbook keeps track of maintenance and every subsheet relates to a different production line. What would be ideal is when the production line adds their issue to their subsheet it adds it to the master list, then when one of the techs updates the issue with "complete" on the subsheet it finds that data on the master list and updates it with the new data.

I have a small simple code for right now that is copying the last row used and pasting it to the master sheet but that doesn't work for when issues before the last row used get resolved.

Thank you in advance.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!