lydia
New member
- Joined
- Jan 29, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi,
I'd like to know if it's possible to use a .csv data file in order to fill out entries in a pre-made Excel file/template. The data at the moment is separated by commas and I've figured out how to get it into individual cells using 'Import from Text' in Excel, however I have a table in another Excel file complete with logos and headings and I'd like to import selected data from the .csv file into the correct fields in the template.
I have a lot of .csv files to do this for and know there must be a quicker way than copy paste!
Not used Macro before but I believe that's the answer. Can anyone shed any light on the challenge please?
I'd like to know if it's possible to use a .csv data file in order to fill out entries in a pre-made Excel file/template. The data at the moment is separated by commas and I've figured out how to get it into individual cells using 'Import from Text' in Excel, however I have a table in another Excel file complete with logos and headings and I'd like to import selected data from the .csv file into the correct fields in the template.
I have a lot of .csv files to do this for and know there must be a quicker way than copy paste!
Not used Macro before but I believe that's the answer. Can anyone shed any light on the challenge please?