Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel catalogue

  • 14-02-2013 9:30am
    #1
    pastasolo
    Registered Users, Registered Users 2 Posts: 14 ✭


    I currently have all the information I want to create a catalogue ready to go(ish)
    I have the catalogue done on individual sheets sheets in a spreadsheet., each sheet is a seperate category.

    so i want to do a contents page and number the pages and basically bring the whole thing together. Any ideas on how i would do this??

    Thanks


Comments

  • #2
    homer911
    Registered Users, Registered Users 2 Posts: 5,150 ✭✭✭homer911


    You can insert hyperlinks in any cell in a workbook to any other cell in a workbook - just use the Insert hyperlink option.

    I doubt if there is any way to automate the creation of this


  • #3
    Diddy Kong
    Registered Users, Registered Users 2 Posts: 937 ✭✭✭Diddy Kong


    There are a number of free macros available that will do this for you, here is one such. Other option is ASAP Utilities which has a lot of useful macros/tools for Excel.


Advertisement