Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple worksheets
I want to manage data on the master worksheet, but at the same time, on two
different worksheets I want the data to automatically input/update. The two different worksheets are spreadsheet reports in different formats. So, what is in column a on the source worksheet may appear in column c in one of the report worksheets and column h in the other. Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple worksheets
J. Hunter wrote:
I want to manage data on the master worksheet, but at the same time, on two different worksheets I want the data to automatically input/update. The two different worksheets are spreadsheet reports in different formats. So, what is in column a on the source worksheet may appear in column c in one of the report worksheets and column h in the other. Is this possible? If I get you, you want to touch the master sheet and have stuff update on the child sheets. To do this you must create formulas on the child sheets to fetch the values from the master. The master cannot "push" values to the child sheets (without VBA). Since you have to set up formulas on each child sheet separately it is immaterial that they have different formats (layouts?), although life would be easier if all the child sheets were set up the same way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge multiple worksheets from multiple excel files into oneworksheet | Excel Discussion (Misc queries) | |||
how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
Updating multiple graphs in multiple worksheets at the same time | Excel Discussion (Misc queries) | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) |