How Do I Get Excel To Display A Reference # based on the number of entries?
Figured out how to do it: Couldn't get a rounding function and row function to work in the same cel, so I created a hidden column to generate the row separately and then a function using roundup and division to create the page number in the column I want it to appear in.
I have a report that I am working with that prints out with 39 entries per page and I want to have a page reference in Excel so I can find something quickly in the printed report. How do I get Excel to generate a number so that fields 1-39 in column A, read as page 1 in column B, fields 40-78 read as page 3 etc...
Further information: These reports can be anywhere from one page to 200+. What I'm trying to do to improve work flow is to get a sheet that can figure the page reference automatically when I enter the data into it.
[link] [comments]
Want to read more?
Check out the full article on the original site