G
Guest
Hello - synopsis - worksheet with 5225 rows and 13 columns - contains dept
numbers and detailed monthly expenses for each dept. I only need info for 20
depts which equals about 500 rows. I've been sorting by Dept number then
deleting the depts I do not need ; then creating a pivot table .
Problem .
Since my dept nos are not in numberical order so I still have to go thru
the list to delete the ones I do use. Is there a way to extract the
department nos I do use instead or deleting the ones I do not use or another
faster way to do complete this task. Thanks
numbers and detailed monthly expenses for each dept. I only need info for 20
depts which equals about 500 rows. I've been sorting by Dept number then
deleting the depts I do not need ; then creating a pivot table .
Problem .
Since my dept nos are not in numberical order so I still have to go thru
the list to delete the ones I do use. Is there a way to extract the
department nos I do use instead or deleting the ones I do not use or another
faster way to do complete this task. Thanks