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-com
fficeffice" /><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?
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-com
fficeffice" /><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?
