Hi,
I have a workbook that has several worksheet.
Everyweek I add several worksheets and edit existing worksheets.
What I want is a 'Add' or 'Update' button on each sheet.
When I click that button I want specifc cell values from that sheet to be copied into a Master sheet in a row.
Each sheet uses the same template.
For example,
I want values in cells A1, B7, D14 and G34 from a sheet added to Columns A, B, C and D on the same rows in the Master sheet.
For new sheets I want a new row to be created in the Master sheet at the bottom (ie next available row).
For updating existing sheet I want the existing row to be updated.
How would I go about doing that?
Here is a shortened version of what I mean.:
http://www.mediafire.com/?4c6zwcflmbokv42
Thanks
I have a workbook that has several worksheet.
Everyweek I add several worksheets and edit existing worksheets.
What I want is a 'Add' or 'Update' button on each sheet.
When I click that button I want specifc cell values from that sheet to be copied into a Master sheet in a row.
Each sheet uses the same template.
For example,
I want values in cells A1, B7, D14 and G34 from a sheet added to Columns A, B, C and D on the same rows in the Master sheet.
For new sheets I want a new row to be created in the Master sheet at the bottom (ie next available row).
For updating existing sheet I want the existing row to be updated.
How would I go about doing that?
Here is a shortened version of what I mean.:
http://www.mediafire.com/?4c6zwcflmbokv42
Thanks
