"mike" wrote in message
ups.com...
I have a workbook named 05-03-31. It contains information for the first
quarter of this year. Sheet 1 references cells on Sheet 2. Sheet 2 was
created by importing a TXT file. I thought I had accomplished something
wonderful at that time.
I now have a new TXT file with second quarter data. I opened the first
quarter workbook, 05-03-31 and saved it as 05-06-30, so now I have a
second quarter workbook. When I Import the second quarter TXT file into
the second quarter workbook it creates a Sheet 3. On Sheet 1 can I
globally change all the references to Sheet 2 to Sheet 3?

Yes, easily. In Sheet 1, Find and Replace. Find "Sheet2" and Replace All
"Sheet 3". (Obviously without the quotes, and substitute the exact names of
your sheets)

HTH