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

Excel catalogue

Options
  • 14-02-2013 10:30am
    #1
    pastasolo
    Registered Users 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

  • Options
    #2
    homer911
    Registered Users Posts: 5,114 ✭✭✭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


  • Options
    #3
    Diddy Kong
    Registered Users 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