Additional comments to previous reply......Each Worksheet's Column A data was
assigned a hyperlink by (Selected A3:A45,etc); Ctrl+K; paste in hyperlink.
Now it appears that the hyperlink attached to the Row and not the actual data
in the row. The rationale for this conclusion: Initially I thought the data
was not sorting properly; subsequent investigation revealed data sorted
properly, what is not sorting is the hyperlink that was assigned to the data.
For instance A4 has data and hyperlink for "Contractor"; when data sorted;
"Office" data is in A4, but the hyperlink for "Contractor" remained in A4
attached to different data. How do I correct?

Chilired

"Chilired" wrote:

I am having an issue with the Master worksheet. Everything appears okay,
however when I assign Auto Filter to Row 2 and sort Column A - Ascending, the
remaining Columns B-F do not sort with Column A. Am I doing something wrong?
Does Auto Filter not work on a Merged worksheet?

Thanks,

"Ron de Bruin" wrote:

I must go now for the weekend
Will reply sunday evening when I am back with a example


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chilired" wrote in message ...
Since the Master Sheet is replaced with each update; how may I code
formatting to include a Worksheet Header and set widths for colunm/row?
Additionally the first two rows of each WS are headers, but they do not
populate since the "start row" is 3 for each sheet.

Thanks,

"Ron de Bruin" wrote:

See the Tips below the macro on
http://www.rondebruin.nl/copy2.htm

Or Replace this :

CopyRng.Copy
With DestSh.Cells(Last + 1, "A")
.PasteSpecial xlPasteValues
.PasteSpecial xlPasteFormats
Application.CutCopyMode = False
End With
With:

CopyRng.Copy DestSh.Cells(Last + 1, "A")

If you want to copy everything.






--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chilired" wrote in message ...
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,