M
Martin ©¿©¬
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?
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?