Thanks!

Ok. Iv'e deleted the macro's and not looking at access and trying to do
this through Vlookups and other functions.

I have information from the rawdata sheet going to the following
worksheets.

"Summary. Shows totals and active projects only"

"Overview - not Started projects sorted in three different ways (by
manager, by # and by hours)

Project list by type (all projects totaled by status (active, not
started, etc),

Project list by manager with totals per manager.

All of this data is on my RawData sheet.

My question is can this different information all pull from the RawData
sheet or do I need to include other hidden sheets to do this? Also,
using a Vlookup or other functions how do i find the "project status -
Cell: AD13 match it to a single option and then pull the whole row of
info? This would be my solution if I can use hidden worksheets.

Thanks!


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=533348