Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Using Excel 2007 In a workbook I have a page (Cong) of names & addresses etc, which are taken from another 14 district pages using paste special link What I would like to happen is that any changes in the 14 district pages (editing, removal, additions etc) are automatically reflected on the Cong page At present, any editing changes are reflected, but any removals show in cells as #REF! (which I then have to remove manually) Also, any additions are not shown (until I insert them manually) My question is:- how should I setup my workbook to acheive the desired results? -- Martin ©¿©¬ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to I make sure that my workbook always opens with a desired sh | New Users to Excel | |||
How to I make sure that my workbook always opens with a desired sh | Excel Discussion (Misc queries) | |||
How to I make sure that my workbook always opens with a desired sh | Excel Worksheet Functions | |||
highlighting cells that have desired results | Excel Discussion (Misc queries) | |||
Results of conditional formatting not what desired. How do I corr | Excel Worksheet Functions |