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
ffice
ffice" /><o
></o
>
RFI's (Would show only RFI's that are still pending)
Submittals (Same as above)Action Items (Same as Above)
Attached is an example of what I am talking about. Should be clear.
http://www.4shared.com/file/mUX1yuz8/Home_Page.html
Please help, I cant seem to figure this out.
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




RFI's (Would show only RFI's that are still pending)
Submittals (Same as above)Action Items (Same as Above)
Attached is an example of what I am talking about. Should be clear.
http://www.4shared.com/file/mUX1yuz8/Home_Page.html
Please help, I cant seem to figure this out.