Import Problem

[Pepper]

Using Excel 2003, my problem is to import from a csv file into Excel. Easy
enough, except I require the top, leftmost cell to be in E10 not A1.
There are a lot of text entries, and formulas already in place, and avoiding
redoing those everytime a download and import is ordered will be a great
enhancement to efficient operations.
Thanks
Pepper

 

[porter444]

What about using "Replace" from the "Edit" menu to fix the formulas that call
A1 and replace with E10? Might not be quite that simple, but could save a
bunch of time.


--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott

 

[Shane Devenshire]

Hi,

You can open a text file directly into Excel via File, Open. In which case
it doesn't matter where you are because Excel automatically opens the file as
a new file, which you can then copy over to any location you choose in
another workbook. You still get the import wizard.

If you are doing this via the Data, Import External Data, Import Data
command you are prompted for the location where you want to put the data so
you can select E1 rather than A1 or any other cell.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire