Page number in a cell

[WERNER SLABBERT]

I need to have the page number automatically entered into specific cells in my sheet.

a header or footer wont work here.

i have 170 page in the sheet wich on them have different items. each of these item codes get recorded on a different sheet including wich page it is on . for reference and indexing purposes. which in turn mean that when i add or delete anything i need to manually re-enter all the page numbers for each item.

ANY help ????

 

[Alteran]

Make a running sum in each cell of each sheet.... this will allow you to calculate the number of sheets and when you remove a sheet it will remove itself from the formula....

IE:

=SUM('Sheet1'!$A1,'Sheet2'!$A1,Sheet3!$A1...)

can try it it has worked in the past.... If not that you can do a VBA script that allows the sheets to be counted in order.... however you would have to run the script manually everytime you changed somthing (you can make a button to run the script)

 

[WERNER SLABBERT]

thanx but the whole problem is that all the pages are on one sheet. so i need something to calculate the total pages according to page breaks.