copying data from a .csv to a .xls

[mas_lerdanch]

Morning all - silly question really - just getting back into excel with a couple of years off! What's the best way of copying data from Column A, Sheet 1, Book 1 (.csv) to Column A, Sheet 1 Book 2 (.xls)?

What's the best and recommended way of doing so?

 

[Richard Schollar]

Hi

Do you mean code or manual solution? Just selecting the column and going Edit>Copy and switching to the xls file and doing Edit>Paste will work manually.

 

[mas_lerdanch]

No what I am looking for is to auto-update every time I open book 2 (.xls) - book 1 (.csv) will not be opened and is downloaded from the internet to a local folder automatically when the file is updated by other users via the web...

 

[Richard Schollar]

I think the easiest way to do that is to create a QueryTable in the xls workbook where you import the csv data to and you can set the query table to refresh on opening the workbook file. The following is an MS guide to dong this:

http://office.microsoft.com/en-us/excel/HA100996641033.aspx

 

[mas_lerdanch]

Hey - I had a go at that the got pure data by selecting the cell on the destination file and typing = in the formula box, then go to the source file and select the cell you want to automatically link to, go back to the destination file and hit return you end up with a link to the specific data.

='csvExport-Questionnaire.csv'!A2

you can always replace the full path for closed documents.

Thanks for your help

Mas