Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 03-09-2010, 12:23 PM
AndrewsGram AndrewsGram is offline Linking text between worksheets Windows 98/ME Linking text between worksheets Office 2003
Linking text between worksheets
Join Date: Mar 2010
Location: Clearwater, FL
Posts: 2
AndrewsGram is on a distinguished road
Default Linking text between worksheets

Workbook contains 8 sheets. Seven are individual listings under category of cases and the eighth is a master list. Is there a way to automatically update the master list sheet whenever text is entered into one of the seven individual sheets? I have tried the paste special link, but that only puts the information into specific cells and not just the next available row in the master list. If anyone knows something I am missing or if it can't be done, please let me know.
Reply With Quote
Old 03-09-2010, 01:26 PM
BjornS BjornS is offline Linking text between worksheets Windows Vista Linking text between worksheets Office 2003
Competent Performer
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road

Hi there,
I have attached one solution that I think works. It is not really a perfect solution (among other it needs some "copy down" of formulas). Perhaps someone comes up with a better solution (I experimented a little with Data / Consolidation. It worked but the result wasn't really satisfying regarding the layout etc).

Short explanation of my proposal for solution (see attachment):
In the sheet "Special" there are constant values in the yellow cells.
Here you also have to name your sheets in the green area.

The solution assumes that you have exactly one header line on each sheet and no empty rows between two records. It also assumes that there is at least one record on each sheet (except for the header). Finally it assumes that number of records on each sheet is given by looking at column A (on each sheet), of course "minus one" for the header.

In the master sheet I think (hope) the formulas speak for themselves. Just copy them "enough down" and make sure to do the same on sheet "Special". As you might notice on the sheet "Master", I have used "conditional formating" to avoid showing error values (= gives white text on white background).

Kind regards
Attached Files
File Type: xls MasterList3.xls (26.5 KB, 19 views)
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking text between worksheets Cells from other worksheets apear on current worksheet Equilar Excel 3 05-03-2010 01:40 AM
Help with worksheets on Word eballi Word 4 11-18-2009 05:17 AM
Linking within the same document tam5070 Word 0 02-06-2009 02:21 PM
linking or something? boonders Word 2 01-07-2009 02:12 PM
Linking Text Fields in a document in Word 2007 lcolson Word 0 12-22-2008 05:14 AM

Other Forums: Access Forums

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

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