A better way to print different excel rows at the same time with excel?

[k3n]

At sheet 1 you'll find the 1st list of rows I'd like to print, each with their unique data.

Through cell referencing, I have created 3 additional sheets, with 4 sections dedicated to the attributes of the corresponding rows.

To select which sheet to print, in this case, the ones with "Row" in their name, 1st left click, then, press and hold the shift button and left click on the last sheet;

or instead of pressing and holding shift, hold the Ctrl key and select each sheet individually.

From there go to File —› Print Preview.

My main question is, what would be a better way to print these rows at the same time, especially without having to resort to multiple sheets?

Please note, my skill in excel is no where near that of an expert level. I do have a basic/introductory understanding of C++ programming language.

Edit: Nevermind. I'll ask at a forum dedicated to excel.

 

[IHateMyJob2004]

Download a random XLS file that could have scripts? No.


Can't you just select the printable area per worksheet and print hte whole workbook ? A workbook = all the sheets. Sheets are the "tabs".

The Google told me that you can do multiple print areas since Excel 2010:
http://answers.microsoft.com/en-us/...el-sheet/7d46d9f2-b04d-4ad7-8387-94d41747ceb6

There is the door, now you walk through it.

 

[k3n]

Download a random XLS file that could have scripts? No.


Can't you just select the printable area per worksheet and print hte whole workbook ? A workbook = all the sheets. Sheets are the "tabs".

The Google told me that you can do multiple print areas since Excel 2010:
http://answers.microsoft.com/en-us/...el-sheet/7d46d9f2-b04d-4ad7-8387-94d41747ceb6

There is the door, now you walk through it.

I'm already familiar with print areas. I'm the one that set each of the 3 tabs with "Row" in their name to print 4 unique rows from "Sheet1" tab. Doing this prevented me from having to make 12 different sheets. 12 ÷ 4 print areas per sheet = 3 sheets, instead of 12 sheets.

I can copy and paste 12 rows of data into "Sheet1", and through cell referencing, i.e., =Sheet1![ColumnLetter][RowNumber], the 3 sheets with 4 print areas of data will automatically update itself.

Is there some sort of Excel macro code/script, that would allow me to use just 1 "Row" sheet, with just 1 print area, and would update the value [Row_Number] in the cell reference formula "=Sheet1![ColumnLetter][RowNumber]", similar to a for loop in Java/C++, after each row has been sent to the printer with a print command?

For example:
A discovery like that would would prevent me from having to make 100 ÷ 4 = 25 sheets with 4 unique area of data; if I wanted to print 100 rows of data at once. Imagine I needed to add a new column(s), it would be a nightmare to go to each sheet on each print area, to make the modification (100 times!).

The data in the "Row" sheet tab are arranged differently from that of Sheet1, so that the entire row of data will fit on one page, instead of 2+ pages, without having to use a smaller font. Imagine if i had 20 columns, instead of 8 columns, the arrangement, would still allow all the data of each row to fit one page.

 

[Tweak155]

I don't get quite what you want to do, but I am an Excel developer in my current position. Whatever you're trying to describe sounds doable

You can issue a print command via macros, as well as set print areas. Sounds like to save paper you'd want to gather all the data to a single location and print the one sheet. It's not too hard to do.