View Full Version : Excel functionality query, please help!!


optimus_1
06-03-2008, 06:31 AM
Afternoon all.

I have a general Excel question regarding the functionality.

My query is:
I have several spreadsheets within a workbook and i want to collate them all to printout on 1 A3 page.
By copying/Pasting them into one new sheet then the width of Columns/Rows effects the appearance etc

I wondered if there is a way of picking parts of several different spreadsheets as they appear and printing them on one sheet.

Hope that makes sense

Regards
Nathan

mdjks
06-03-2008, 09:30 PM
http://www.asap-utilities.com/

download this add-in, use sheets, combine rows

it has tons of other really useful tools as well

optimus_1
06-05-2008, 02:35 AM
Thanks for that,

I will download that at home on my personal pc.

My only problem is that currently i am having to use this at work and due to network priviledges i am unable to download such files.

I was wondering if there is a sort of quick fix i could use in vb etc...

Thanks again
Nathan