I have attached a workbook that should help show what I would like to achieve.
The first page in the work has an inventory list with boxes left blank. When the boxes are filed the totals go over to a corresponding box on sheet 2.
The first page will eventually have "command buttons" that will add or subtract a value from the adjacent cell. I filled in a few as an example. (I do not need help with these).
The second page has repetitive inventory. With each section representing a particular floor.
What I would like is to be able to populate the first sheet (Lets call it first floor). Hit a button and it transfers the data to appropriate cells In the second sheet. Then I would like the first sheet data to "clear" and "reset".
Whereby, if there is a second floor, I could populate sheet 1 again and have the data transferred to floor 2. "clear" and "reset"
etc. etc.
I wonder should I be achieving my goal with a "user form", Module, or a combination.
Any help would be appreciated.
TBM
Bookmarks