How to filter specific cell data and copy entire rows.
Office 2007, 2010
This is my original sheet
I like to copy entire rows having value 0.00 in column B
1- select column B
2- click on data tab
3- click on filter
4- Click on arrow (circled) in column B top
5- From list select 0.00, ok
6- Now copy the data and paste in new sheet
Ok
Office 2007, 2010
This is my original sheet
I like to copy entire rows having value 0.00 in column B
1- select column B
2- click on data tab
3- click on filter
4- Click on arrow (circled) in column B top
5- From list select 0.00, ok
6- Now copy the data and paste in new sheet
Ok
