NV Social Worker
New Member
- Joined
- Nov 9, 2020
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
I have a workbook with formulas that result in blank cells, unless data is placed in other cells (A16:Y300). I only want the pages with data in them to print, but it is trying to print all of the blank pages that have formulas in them (I have rows 1:15 to print for each page). I am not familiar with macros or VBA, and am only moderately familiar with formulas. I know I can put in a filter to not print the blank pages, but I have people who will be using the workbook that can barely even input the data, and would not know how to use the filter. I would like for them to just click print and only the pages with data to print (currently, it is printing 10 pages). I looked through the message board and found this, which I have tried to no avail:
To not print formulas in blank cells:
Go to Formulas Tab
Click on Define Name
In Name box, type name of worksheet and Print_Area
In Scope box, click on the workbook
In the formula box (Refers to type in …
=OFFSET(Service Log!$A$1:$Y$1,0,0,LOOKUP(2,1/(Service Log!$A$2:$A$300<>""),ROW(Service Log!$A$2:$A$300)))
If anyone can assist me with this issue, I would be most grateful.
Thank you,
NVSW
To not print formulas in blank cells:
Go to Formulas Tab
Click on Define Name
In Name box, type name of worksheet and Print_Area
In Scope box, click on the workbook
In the formula box (Refers to type in …
=OFFSET(Service Log!$A$1:$Y$1,0,0,LOOKUP(2,1/(Service Log!$A$2:$A$300<>""),ROW(Service Log!$A$2:$A$300)))
If anyone can assist me with this issue, I would be most grateful.
Thank you,
NVSW