ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do i create a template (https://www.excelbanter.com/excel-discussion-misc-queries/4039-how-do-i-create-template.html)

Storm

How do i create a template
 
I want to create a spreadsheet that will house and print out groups of data
imported from another source. I have created a template and imported one set
of data which I then printed out, but am having trouble importing the next
set of data I want to print out in the same format.

Basically, I have report information that isn't set up in a printer-friendly
format. I want to import the data into Excel and select certain of the
fields to print. Since I need to print these reports daily, I want to
memorize the spreadsheet so I don't need to keep recreating it.

Dave Peterson

First, I don't really understand what you're doing, but you may want to think
about using a macro that will rearrange your data the way you like it.

Just import the data, run the macro, and print.

Maybe recording a macro when you do it once manually would be a good way to
start.

Storm wrote:

I want to create a spreadsheet that will house and print out groups of data
imported from another source. I have created a template and imported one set
of data which I then printed out, but am having trouble importing the next
set of data I want to print out in the same format.

Basically, I have report information that isn't set up in a printer-friendly
format. I want to import the data into Excel and select certain of the
fields to print. Since I need to print these reports daily, I want to
memorize the spreadsheet so I don't need to keep recreating it.


--

Dave Peterson


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com