Excel catalogue

pastasolo · 2013-02-14 09:30:48

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??…

14-02-2013 09:30AM

#1

pastasolo

Registered Users, Registered Users 2 Posts: 14 ✭

Join Date: January 2013

Posts: 4

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

0

Comments

#2 14-02-2013 10:21AM

homer911

Registered Users, Registered Users 2 Posts: 5,069 ✭✭✭

Join Date: September 2007

Posts: 4684

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

0
#3 18-02-2013 09:33AM

Diddy Kong

Registered Users, Registered Users 2 Posts: 937 ✭✭✭

Join Date: November 2003

Posts: 862

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.

0