Attached is an edited version which deals with the deleting request.
Re adding the 17 sheets- do you essentially want to duplicate the 'FRONT' sheet 17 times? Are these to be named according to some convention? If you can clarify precise intentions, I might get a chance to look at the coding.
Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
Hi deadlyduck
This seems to be on the right track
I've added the 17 sheets but have only added the cell links to the first 3 so you can see what I'm trying to achieve (I'll save the tedious linking for later)
On the front sheet I would like to see the "Delete all" (with associated popup) at the end of each row, therefore the delete all will only apply to columns in that row and the associated sheet white cells (user accesses via Handover link).
The sheet tabs will eventually be hidden and the work book protected to minimise error risk from users
hope this clarifies and thanks for your work so far
Langworth PSAG 2023 ver 3a.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks