need something similar. i have a list of manufacturers' and their respective
products on a sheet. items on this list are constantly being added and
removed. this list is also filtered so that certain data can be printed. On a
master sheet I want to be able to list the pages that a particular
manufacturer's items are on, even when this list of items is filtered.

I figure if I can get access to the page number like danny then I would be
good to go.

MidNiteRaver
Kingston, Jamaica

"DannyG" wrote:

Certain data in my spreadsheet has to reference to a specific page number
when the spreadsheet is printed. I can't find a formula that would provide
information about a page number (something like =CELL("filename"))

Any help would be appreciated.