replacing Sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advance Lookup Functions 4
find and copy it.. 2
Merge Multiple workbook sheets into one workbook 0
finding cells on diferance sheets 1
Copy Unique Record 2
How to change sheet names via formula 3
Auto generate sheets by different values of a cell. 4
Excel Move or Copy Stopped Working? 0

Back
Top