LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Merge Worksheets w/Comments & Hyperlinks

I successfully used the example from http:/www.rondebruin.nl.copy2.htm site
to merge 10 worksheets into one Master sheet; however the issue is I have
comments and hyperlinks on the individual sheets. Is is possible for the
comments to come with the data and also have active hyperlinks in the merged
Master document? The desired result will be to use Autofilter on the header
row of the Master document and protect the sheet for use on our Intranet
site. Is this possible? Please advise.

Thanks,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks and Comments Chilired Excel Programming 0 September 17th 08 06:31 PM
How to merge worksheets on a key - merge horizontally, that is [email protected] Excel Programming 4 November 4th 06 12:59 AM
I am losing comments when i merge work sheets? Any one know how t Martin Stephenson Excel Discussion (Misc queries) 0 June 1st 06 05:25 PM
COMMENTS ON PROTECTED WORKSHEETS Chad New Users to Excel 1 February 1st 06 07:29 PM
How do I print comments and or Hyperlinks setup in cells in Excel. Ray de Laune Excel Discussion (Misc queries) 1 February 9th 05 11:17 PM


All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"