| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
= function - can data be changed in both places?
Hi,
I have a master sheet that has all of my data and then separate tabs that only have certain data. Currently I have been using the = function to get the data from the master sheet to appear on the other sheets. Is there a way that I can make it so that I can change data in either place (master sheet or tabs) and the related data in the other place updates automatically? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
= function - can data be changed in both places?
Nikki
Only through event code. See this google search thread for sample code. http://tinyurl.com/ynw86x Gord Dibben MS Excel MVP On Mon, 6 Aug 2007 14:10:00 -0700, Nikki wrote: Hi, I have a master sheet that has all of my data and then separate tabs that only have certain data. Currently I have been using the = function to get the data from the master sheet to appear on the other sheets. Is there a way that I can make it so that I can change data in either place (master sheet or tabs) and the related data in the other place updates automatically? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Multiple Places Changing | Excel Discussion (Misc queries) | |||
| Date function in Excel that updates only when a doc is changed? | Excel Worksheet Functions | |||
| Aligning data with varying decimal places | Excel Discussion (Misc queries) | |||
| Insert function changed | Excel Worksheet Functions | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
Linear Mode
