Hello Excel Gurus,
I require a macro in the form of a button called "update record" that will update a table/list every time a new worksheet is created. In essence this list is like a table of contents.
The headings in the list will look like:
Cheque# Name Date Amount
The cheque number will be populated every time a new worksheet is created with the name of the cheque number. I will be using the move-or-copy function in excel to copy a worksheet and will rename the worksheet name with a new "Cheque Number". New worksheets are added daily so the workbook keeps on growing.
The name, date and amounts are in the same row/column positions in every worksheet but will need to be referenced in the list and also be updated with the details from the newly created worksheet. There are also about 50 or so worksheets that are already in the workbook so I'm wondering if the details of these worksheets can also be linked to the table.
Appreciate any help.
Thanks
Bookmarks