Inserting page numbers in a cell

D

DannyG

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.
 
M

MidNiteRaver

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
 
D

David McRitchie

Please don't step on someone else's thread before they have an answer
a "me too" posting before the answer can be very distracting.. Your
answer could be solved by two more columns on a help column.


In answer to Danny's question, the Original Poster, first of all
the CELL function needs two operands or you are in trouble see
http://www.mvps.org/dmcritchie/excel/pathname.htm

Back to the actual question,
Page number, inserted into a cell, Laurent Longre, Myrna Larson.
http://groups.google.com/[email protected]
 
Top