export excel to PDF so that bookmarks are named as cell for each page of a worksheet

mscott23

New Member
Joined
Mar 30, 2011
Messages
1
I am working in Windows XP with Excel 2007. I am trying to export an excel file to PDF so that the bookmarks for each page are named the same as a certain cell on each page. For example, one of the sheets has 84 different pages. Each page contains two colums 21 Rows. The first column on row 16 on each page contains the name of what I would like the bookmark of that page to be called, so Page 1 would be named what is in cell B16, Page 2 would be named what is in cell D16, and so on. Is this something that is possible to do?

Thanks!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,108,630
Messages
5,523,989
Members
409,553
Latest member
alscno

This Week's Hot Topics

Top