I have a large spreadsheet which is ordered
dept - cat - spend
The number of rows for each department can vary, depending on when the
data is updated. I am looking for a way to transfer just the data for
particualr departments into a new sheet, simple linking won't work as
the number of rows alters by department.
Sorry if that sounds a bit vague.
Any suggestions?
Thanks
--
sanders
------------------------------------------------------------------------
sanders's Profile:
http://www.excelforum.com/member.php...o&userid=36745
View this thread:
http://www.excelforum.com/showthread...hreadid=565574