Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating data in one Worksheet and propagating it to others
HI
I have a 3 page worksheet listing all the schemas I maintain, with each page representing a different view; by DB type, region, customer etc. Each sheet is exactly the same except for how the data is ordered (by DB, region etc). Is there a way that I can update the data in sheet #1 and then have it automatically update the other two sheets? I've tried to find the info online, no joy, and I've also tried playing around with references, but can only get it to work for individual cells Thanks No1Dub |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating data in one Worksheet and propagating it to others
I think the lack of responses so far indicates that you've not really
given much detail to go on. If you describe what data you have (columns, rows, type etc), sheet names, how the data is organised and linked, together with what you want to achieve, then it gives respondents more to get to grips with. Pete On Jul 3, 8:47*pm, Number1Dub wrote: HI I have a 3 page worksheet listing all the schemas I maintain, with each page representing a different view; by DB type, region, customer etc. *Each sheet is exactly the same except for how the data is ordered (by DB, region etc). * Is there a way that I can update the data in sheet #1 and then have it automatically update the other two sheets? I've tried to find the info online, no joy, and I've also tried playing around with references, but can only get it to work for individual cells Thanks No1Dub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create auto updating data validation list from all worksheet names | Excel Worksheet Functions | |||
Comparing Data and Updating a worksheet | Excel Discussion (Misc queries) | |||
"propagating" a chart across a number of data sets | Charts and Charting in Excel | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions |