Summary Page (Showing only Outstanding Items in Summary Page)

[LogMil82]

I am a project manager for a subcontractor in Dallas. I am consistently looking for better ways to manage all of the data that comes into my office. I have to track Purchase Orders, RFI's, Submittals, Action Items &/or Requested Information, Critical Delivery Dates, etc. Right now I have several workbooks that manage each individual item.
I have several things I want to do; however, I want to start with consolidating the information first, and creating a "Home Page". Once I have consolidated all of the workbooks into one, I Need your help in creating the "Home Page" that has a separate section for each category, i.e.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Purchase Order (Would show only POs that don’t have a "Yes" in a particular Column)
*item (Column for PO #, Due Date (Sorted by this Earliest to Latest), Vendor, Cost Code)*item
*and so forth
<o> </o>
RFIs
*Item
*Item
<o> </o>
You get the picture. So how do I pull only information into this sheet and when it pulls information in it will insert or delete rows as needed to fit into that category?

 

[Akashwani]

Hi,

Welcome to MrExcel.

Take a look here to see if this gives you some ideas...

Sample Database.xls

This has a Master sheet and a Lookup sheet (Homepage) that allows you to lookup various data based on the criteria given and returns all the relevant data.

Ak

 

[LogMil82]

Thanks for your help so far! However, my excel skill are still lacking unfortunately. I looked at what you had created and couldn't figure out how to incorporate it into what I was hoping to accomplish. See the attached file and tell me what you think. Not sure how to do this....

[FONT=Verdana][COLOR=black]http://www.4shared.com/file/mUX1yuz8/Home_Page.html[/COLOR][/FONT]
[FONT=Verdana][COLOR=black][/COLOR][/FONT]
[FONT=Verdana][COLOR=black][/COLOR][/FONT]

This is the first time I have attached a file on here, I hope this works.