Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update data automatically among worksheets
I have 10 worksheets in one workbook. On every worksheet, from A1 to M100
are the data I use for calculations. These data are exactly the same on every worksheet (I placed them on every worksheet so that it is easier to link and check numbers). Right now the data on worksheet 2 to 9 are linked to worksheet 1, so when I want to revise/refresh the data, I make changes on worksheet 1, and the changes are reflected on other worksheets through the links. I wonder, if there is a way that allows me to make changes on any worksheet, and then automatically update the data on other worksheets? Maybe there is a OnChange event in VBA? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update data automatically among worksheets
You have a sheet_change event that can be trapped by following Sub in
Workbook code: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As R HTH -- AP "Leo" a écrit dans le message de news: ... I have 10 worksheets in one workbook. On every worksheet, from A1 to M100 are the data I use for calculations. These data are exactly the same on every worksheet (I placed them on every worksheet so that it is easier to link and check numbers). Right now the data on worksheet 2 to 9 are linked to worksheet 1, so when I want to revise/refresh the data, I make changes on worksheet 1, and the changes are reflected on other worksheets through the links. I wonder, if there is a way that allows me to make changes on any worksheet, and then automatically update the data on other worksheets? Maybe there is a OnChange event in VBA? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Query will not Refresh automatically | Excel Worksheet Functions | |||
update consolidated sheet when data is added to worksheets | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |