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
|