replacing Sheet
 

I have a master (named Country) sheet which is taking data from another sheet
(named City) in the workbook through the links. Every week i am getting an
updated city sheet from my data entry operator. I want to replace the old
city sheet with the new city sheet with the same name. But when i delete the
old sheet and copy the new sheet with the same name, the master (Country)
sheet is showing #REF! in its cells.

Is ther any way i can accomplish this so that i can save my time from copy
and paste?

thankx!

replacing Sheet
 

Can you just clear the cells on that City sheet.

Then select the cells on the new City sheet, edit|copy
off to the old City sheet
select A1 and edit|paste



create_share wrote:

I have a master (named Country) sheet which is taking data from another sheet
(named City) in the workbook through the links. Every week i am getting an
updated city sheet from my data entry operator. I want to replace the old
city sheet with the new city sheet with the same name. But when i delete the
old sheet and copy the new sheet with the same name, the master (Country)
sheet is showing #REF! in its cells.

Is ther any way i can accomplish this so that i can save my time from copy
and paste?

thankx!

--

Dave Peterson