Excel functionality query, please help!! (1 Viewer)

[optimus_1]

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]

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]

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