gordon3d
New Member
- Joined
- Mar 26, 2004
- Messages
- 37
I am importing data from another spreadsheet using Excel's Import External Data/Import Data etc and when I get to the "Select Table", I see some Named Ranges are listed and others are listed with a "$" at the end.
For example: Data_Bu (named range) is listed as Bu$. Importing using this Bu$ gives a difference rance which includes titles etc which I do not want.
Others: Data_Carbon is listed in "Select Table" as Data_Carbon.
What has happened to my orifinal named range? I can see it in the original source spreadsheet but not in the "Select Table".
For example: Data_Bu (named range) is listed as Bu$. Importing using this Bu$ gives a difference rance which includes titles etc which I do not want.
Others: Data_Carbon is listed in "Select Table" as Data_Carbon.
What has happened to my orifinal named range? I can see it in the original source spreadsheet but not in the "Select Table".