Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-01-2014, 07:16 AM
taxacct taxacct is offline Linking Workbooks/Entire Worksheets to Identical in Master Windows XP Linking Workbooks/Entire Worksheets to Identical in Master Office 2007
Novice
Linking Workbooks/Entire Worksheets to Identical in Master
 
Join Date: Oct 2014
Posts: 1
taxacct is on a distinguished road
Default Linking Workbooks/Entire Worksheets to Identical in Master

This is quite complicated. I have one master file containing, lets say Sheets A,B, & C. I want to save Sheets A,B, & C as separate workbooks.. then when those workbooks are updated with new information, I would like those same changes to transfer to the master file, containing the identical sheets. Does anyone have any guidance? Possibly linking an entire worksheet? Am I thinking of this incorrectly?
Reply With Quote
  #2  
Old 10-01-2014, 09:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Linking Workbooks/Entire Worksheets to Identical in Master Windows 7 64bit Linking Workbooks/Entire Worksheets to Identical in Master Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,506
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Please do not cross post without links !Read this to understand why : http://www.excelguru.ca/content.php?184

http://www.excelforum.com/excel-prog...in-master.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 10-01-2014, 11:22 AM
gebobs gebobs is offline Linking Workbooks/Entire Worksheets to Identical in Master Windows 7 64bit Linking Workbooks/Entire Worksheets to Identical in Master Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Also, If you don't mind, could you explain a bit more why you need to do this? Will the new data be updating existing records, are new records being added, or both? If at all possible, attach the master file.
Reply With Quote
Reply

Tags
linking, workbooks

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
identical slides in powerpoint - linking shansom2904 PowerPoint 1 09-01-2014 08:13 AM
flag identical words? 21rouge Word 1 09-21-2013 08:42 AM
VBA: Creating new Worksheets from two different Workbooks Johana Excel Programming 1 09-07-2012 09:30 PM
Multiple identical fields snorkerz Word 4 06-25-2012 02:30 PM
Linking Workbooks/Entire Worksheets to Identical in Master Linking text between worksheets AndrewsGram Excel 1 03-09-2010 01:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:24 PM.


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