Can I use AUTOFILTER cell "TEXT" and display in an

[KennyC]

Hi,

I'm creating a Hazardous Substances Register and I'd like to know if it is possible to use the text within a merged cell that I select to AUTOFILTER, and add this text to another cell.

In the image, I'm using autofilter in cell Q10 and want to display Sluice Room in merged cell M9.

If not possible or too difficult, no biggy as I'll just copy/paste the text from cell to cell.

Cheerz

 

[Bruno_x]

Re: Can I use AUTOFILTER cell "TEXT" and display i

Look at :
http://www.mrexcel.com/board2/viewtopic.php?t=26626&highlight=criteria2