I think this may be of help. Create your template with a single sheet, including a reference cell (e.g A1, column A could be hidden) and place the following formula in the cells that have to contain your csv data.
=INDIRECT(ADDRESS(ROW(A2);COLUMN(A2);0;INDIRECT("A1")))
Replace cell references for row and column to suit your csv file, you can replace the row and column functions with the appropriate row and column number, it depends whether you want them to be relative. INDIRECT("A1") refers to the reference cell.
Now open a new document, using your newly created template. Go to Insert > sheet > from file and browse for your csv file. Once inserted, you can right click on the sheet tab to rename it, if required.
Return to your original sheet and enter the name of the inserted sheet in the reference cell. The values you require should appear.
Further sheets can be added, only requiring the reference cell to be changed to reflect the new sheet name.
HTH
Barrie
Thanks Barry, thats an interesting idea.
I have a direct link to each cell on a second sheet at present but I will give your more elegant idea a go, it saves global search & replaces :) - once I have solved my immediate problem that is.
All my spreadsheet works except ONE coloumn. The links & formula are all invisible except for the one coloumn where all I can see is '=Sheet1_2.F43' etc as the coloumn decends.
I have checked tools>option>spreadsheet>view & formula display is off.
I have checked format cells, nothing abnormal, just text like other working coloumns
Any ideas
Dave
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
