Creating an "update" button and using a macro to copy data from multiple sheets

  • Thread starter Thread starter SPIRITTTJ
  • Start date Start date
S

SPIRITTTJ

I created a workbook with multiple sheets to record and track forms. The
workbook consists of 6 worksheets, one of them being a summary
worksheet. Five of the worksheets are accessed by different people
responsible for updating their data.

My goal is to create an "Update" button on the summary sheet. When a
user makes a change on a worksheet, the change should be reflected in
the summary page. E.g., If a user adds a new row of data on their
sheet, the row will be added to the summary sheet when he clicks on the
"Update" button. Likewise, if a user makes changes to existing data
within a row, the change will be added to the summary sheet when the
"Update" button on the summary sheet is clicked.

If possible, the update should only "copy" new data entries from all
sheets to the summary sheet.


Thanks a bunch!!

:confused:

Attachment filename: sp-10 tracking sample for forum.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=401079
 
Two ways to go:

try using consolidate data.. a builtin function provided in excel
itself.. looking to your workbook i think it can solve your problem.
 
Back
Top