Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
One report from multiple pages
My Accounts Receivable is an Excel file with a sheet set up for each of my 40
clients like a basic ledger. My totals (charges incurred, paid, credits, balance) are on row 262 of each sheet. Can you direct me to a reporting/printing function that will print a report with just that one row of all sheets without beginning a new page for each sheet? So far all I can generate is 40 pages of one-liners. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
One report from multiple pages
Make another totals sheet that refers to the total cell of the other sheets:
=sheetname!a262, or whatever column it is. If you use "insert" on the other sheets, it should change the cell reference on the totals sheet so you don't have to change it all the time. "RobertM" wrote: My Accounts Receivable is an Excel file with a sheet set up for each of my 40 clients like a basic ledger. My totals (charges incurred, paid, credits, balance) are on row 262 of each sheet. Can you direct me to a reporting/printing function that will print a report with just that one row of all sheets without beginning a new page for each sheet? So far all I can generate is 40 pages of one-liners. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
One report from multiple pages
Thanks for your suggestion. I'm hoping to get away from typing 40 rows of
sheetnames, especially since I add and remove sheets monthly. "dlw" wrote: Make another totals sheet that refers to the total cell of the other sheets: =sheetname!a262, or whatever column it is. If you use "insert" on the other sheets, it should change the cell reference on the totals sheet so you don't have to change it all the time. "RobertM" wrote: My Accounts Receivable is an Excel file with a sheet set up for each of my 40 clients like a basic ledger. My totals (charges incurred, paid, credits, balance) are on row 262 of each sheet. Can you direct me to a reporting/printing function that will print a report with just that one row of all sheets without beginning a new page for each sheet? So far all I can generate is 40 pages of one-liners. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
One report from multiple pages
Is there a way to make =sheetname a variable and populate it from a list of
sheetnames? "dlw" wrote: Make another totals sheet that refers to the total cell of the other sheets: =sheetname!a262, or whatever column it is. If you use "insert" on the other sheets, it should change the cell reference on the totals sheet so you don't have to change it all the time. "RobertM" wrote: My Accounts Receivable is an Excel file with a sheet set up for each of my 40 clients like a basic ledger. My totals (charges incurred, paid, credits, balance) are on row 262 of each sheet. Can you direct me to a reporting/printing function that will print a report with just that one row of all sheets without beginning a new page for each sheet? So far all I can generate is 40 pages of one-liners. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple values to report a third | Excel Worksheet Functions | |||
Multiple page report in a pivottable | Excel Discussion (Misc queries) | |||
How to link multiple invoices to a report? | Excel Discussion (Misc queries) | |||
multiple pages for multiple users | Excel Discussion (Misc queries) | |||
ONE PAGE REPORT WANTS TO PRINT 1311 pages in each copy, WHY? | Excel Discussion (Misc queries) |