Thread: [Solved] Copy Row based on yellow highlighting.
View Single Post
 
Old 09-28-2011, 01:24 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Hi
You could try using an Advanced Filter that copies discrete rows where a column contains the word "faculty" to a new sheet.
Hope this helps.
Good luck.
Tony(OTPM)
Reply With Quote