MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Moving Data


Posted by Anthony on July 24, 2001 8:15 AM

Hello! If the criteria meets a certain condition...for (e.g. any item < 10%) can these rows be placed into another worksheet?

Thanks

Anthony


Posted by lenze on July 24, 2001 9:33 AM

Yes See Advanced Filter Help. Check on filter to new location

Posted by Anthony on July 24, 2001 12:11 PM

Thank you!