Thread: [Solved] Master tab data list parsed out to applicable cells in applicable worksheets
View Single Post
 
Old 10-27-2017, 04:47 PM
kiwimtnbkr kiwimtnbkr is offline Windows 10 Office 2010 64bit
Advanced Beginner
  
Join Date: Oct 2017
Posts: 69
kiwimtnbkr is on a distinguished road
Default
couple more queries

Should I need to insert a new row for a new device with its Ser no., Type and User, how would you re-run the macro to just create the new worksheet, it's hyperlink and have it inserted in the correct place?
Is that even possible?

And if the User of a particular device changes, how would you re-run the macro to update just the affected worksheet?

I realise I am asking a lot but I just can't find the right topics to answer my queries.

cheers
Mike
Attached Files
File Type: xlsm DTD workup_new_clean.xlsm (51.5 KB, 9 views)
Last edited by kiwimtnbkr; 10-27-2017 at 04:56 PM. Reason: Spreadsheet re-attached
Reply With Quote