Templates for imported data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all thanks in advance for any reply.

I want to create a template where I can import data from a csv file into a
standard format in a Excel worsheet. The data will change on a week by week
basis but I want the output style to remain the same.

Can anyone make any suggestions?

Again, many Thanks

Michael
 
One option is to import the data into a sheet, then record a macro as you
change the layout to what you need. Delete the data, but keep the macro then
save the "empty" sheet as a template.

For future use open a sheet based on the template, then run the macro after
importing the data.

Ian
 
Back
Top