Comments not displayed when using ADVANCE FILTER

[mohan.shocks]

Hi,

While using ADVANCED FILTER to extract certain criteria from the database to another sheet, the COMMENTS in the respective cells in the Data base not displayed (or) copied in the destination sheet. Kindly guide me to solve the issue.

- Mohan.

 

[robertgama]

Probably just use the regular filters then copy / paste?

Are you trying to only bring over unique values?

 

[robertgama]

Like this...and your comment will be copied over:

 

[mohan.shocks]

Probably just use the regular filters then copy / paste?

Are you trying to only bring over unique values?

@ Robertgama,

While using regular filters then copy / paste it works.

My concept is not to disturb the main data base for filtering purpose which is protected, hence used macro enabled Advance filter to extract the contents required.

Except the COMMENT all the formats were displayed, need help.

- Mohan.

 

[mohan.shocks]

Hi VoG,

Kindly help me to resolve this problem.

regards

Mohan.

 

[MARK858]

Have a look at the link below and see if that helps you

http://excelribbon.tips.net/T010284_Copying_Comments_when_Filtering.html

 

[mohan.shocks]

Have a look at the link below and see if that helps you

http://excelribbon.tips.net/T010284_Copying_Comments_when_Filtering.html

Hi MARK858,

THANKS

The above link you shared really helpful to solve my problem, really appreciate your guidance.

regards,

-Mohan.