Thread: Problem Importing a TXT File

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?
I tried deleting Sheet 2 and then importing the new data into a new
Sheet 2. This imported the data onto Sheet 2 properly but on Sheet 1
all the references to Sheet 2 were now 'errors'.
I am open to any method that will get me up and going as I will have
this problem again when I attempt the third quarter data
Thanks for any and all help.

"mike" <trvlnmny@yahoo.com> wrote in message
news:1121115518.602221.60330@g44g2000cwa.googlegroups.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