ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Two worksheets, one printout? (https://www.excelbanter.com/excel-discussion-misc-queries/93478-two-worksheets-one-printout.html)

Rachael

Two worksheets, one printout?
 
I have an unusual question.

It's in relation (kind of) to a question I posted earlier. I have data in
columns A to BZ (times) that are totaled in Row 49. The totals are pulled
down below row 49 for some simple accounting/calculations.

Columns A to BZ have "rates" in them, so any time data is entered, so most
columns are not used each time. Any column not used is then hidden, as in
most cases only 5-10 columns are used.

Problem is, I cannot hide columns A to E, because that is where my
accounting calculations are below.

Both sets of data (the top part and bottom calculations) need to be printed
on one page each week.

Is there a way that if I move the lower data to another sheet in the same
workbook, that I can print them on the same page?


All times are GMT +1. The time now is 07:00 AM.

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