Is there a way to update fields on a master sheet when a spreadsheet is inserted?
Is there a way to update fields on a master sheet when a spreadsheet is inserted?
Sure, use the NewSheet event of the workbook object, as soon as a new sheet is inserted the code will be triggered, since you don't have much information some sort of copying and pasting will probably take place or whatever you set on the code to execute for updating of the master sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks