Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening file problem please help | Excel Discussion (Misc queries) | |||
cannot open documents as viruscan says problem file? | Excel Discussion (Misc queries) | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |