If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I automatically repeat data in several excel workbooks
I am trying to update the same text / numerical data in 3 different workbooks
at one, can anyone help? Eg, if I input a name in one sheet I want it to appear in all 3. |
#2
|
|||
|
|||
if the data in cell A1 of Sheet1 is to appear in cell A1 on both Sheet2 and Sheet3, that could be done by providing the formula in Sheet2 and Sheet3 by using the formula =Sheet1!A1. -- icestationzbra ------------------------------------------------------------------------ icestationzbra's Profile: http://www.excelforum.com/member.php...fo&userid=4580 View this thread: http://www.excelforum.com/showthread...hreadid=272087 |
#3
|
|||
|
|||
If you highlight all the sheets you want to update, click on your 'master sheet' and type in the info. This will appear on the other highlighted sheets. Dan. -- Voodoodan ------------------------------------------------------------------------ Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597 View this thread: http://www.excelforum.com/showthread...hreadid=272087 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA Code problem error 9 | Speedy | General Discussion | 19 | October 15th, 2004 09:05 PM |
lost data when opening excel workbooks ; text import wizard popup | craig l | General Discussion | 0 | August 14th, 2004 04:43 AM |
Struggling with MS Query... | Alex | General Discussion | 5 | July 6th, 2004 11:46 AM |
Too many data points in Excel Chart | Jo | Charts and Charting | 1 | April 5th, 2004 03:53 PM |