Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2017, 01:40 PM
kiwimtnbkr kiwimtnbkr is offline Master tab data list parsed out to applicable cells in applicable worksheets Windows 10 Master tab data list parsed out to applicable cells in applicable worksheets Office 2010 64bit
Advanced Beginner
Master tab data list parsed out to applicable cells in applicable worksheets
 
Join Date: Oct 2017
Posts: 69
kiwimtnbkr is on a distinguished road
Default


that is EXACTLY what I was after!!

Can't thank you enough for your assistance! Absolute legend
Reply With Quote
  #2  
Old 10-27-2017, 04:47 PM
kiwimtnbkr kiwimtnbkr is offline Master tab data list parsed out to applicable cells in applicable worksheets Windows 10 Master tab data list parsed out to applicable cells in applicable worksheets Office 2010 64bit
Advanced Beginner
Master tab data list parsed out to applicable cells in applicable worksheets
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Master tab data list parsed out to applicable cells in applicable worksheets Column B Cell 25 of all worksheets copies data found in the lower cells ... rpcalo Excel 3 03-10-2016 03:38 AM
Master tab data list parsed out to applicable cells in applicable worksheets Move Data from Master List to Sheets with City Name meggenm Excel 3 01-28-2016 10:18 AM
Master tab data list parsed out to applicable cells in applicable worksheets Creating Word document that automatically inputs text into applicable fields, jjfromnj Word 3 12-04-2015 10:00 AM
Master tab data list parsed out to applicable cells in applicable worksheets seprate process data from main master list Santhosh AMASL Excel 1 01-12-2015 09:33 AM
Linking Workbooks/Entire Worksheets to Identical in Master taxacct Excel 2 10-01-2014 11:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft