Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am creating a page index sheet of the items in successive work sheets. How
do I insert the page number of a particular item/cell in a worksheet in this first index sheet. I guess it requires linking of the sheets and probably some function. Can anybody help. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A couple of ways,
On the index sheet put the name of the item you want to link to in a cell eg. widget You can now do several things. Firstly you can simply right click widget and create a hyperlink to "a place in this document" where the details for widget are. You can name the cell in you worksheet where the details for widget are and likewise create a hyperlink to that name in the same way as above, This time instead of going to the appropriate worksheet it goes to the specific cell that caontains the data. "Nandkish" wrote: I am creating a page index sheet of the items in successive work sheets. How do I insert the page number of a particular item/cell in a worksheet in this first index sheet. I guess it requires linking of the sheets and probably some function. Can anybody help. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
When i Print the excel sheet, the first page shall be the index sheet, which
shall list the page numbers of the various topics mentioned in the adjacent sheets. This page number in the index sheet has to be automatically updated if the contents in the adjacent sheets crosses a page limit and goes to the next while printing. I cant really use hyperlink as it will work only in open worksheet in a PC and not on printed matter which is submitted as hardcopy. I cant really make use of the insert page number function available in header footer in the normal work sheet. "Mike" wrote: A couple of ways, On the index sheet put the name of the item you want to link to in a cell eg. widget You can now do several things. Firstly you can simply right click widget and create a hyperlink to "a place in this document" where the details for widget are. You can name the cell in you worksheet where the details for widget are and likewise create a hyperlink to that name in the same way as above, This time instead of going to the appropriate worksheet it goes to the specific cell that caontains the data. "Nandkish" wrote: I am creating a page index sheet of the items in successive work sheets. How do I insert the page number of a particular item/cell in a worksheet in this first index sheet. I guess it requires linking of the sheets and probably some function. Can anybody help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
insert a page number into a cell? | Excel Worksheet Functions |