I would like to create a summary page in my excel workbook. My workbook is setup as follows:
Template
Table of Contents
Request PMT Status
Project 1
Project 2
Project 3
Project 4
Project 5
Project 6
Project 7
The summary page would be on the Request PMT status tab. On each of the Project tabs there is a table that has this information:
If there is a $0.00 amount in any of the tables I would like it to copy the information to the request pmt status worksheet. I would want it to pull the following information:
Invoice # - Amount - Cycle - PMT Amount.
Side Note: This is my test workbook. Eventually I will have a workbook that will need to pull from about 100-150 projects (each on their own worksheet) so ideally this would need to be able to be utilized for a large quantity of data.
Any advice on how I could achieve my desired results would be much appreciated.
Template
Table of Contents
Request PMT Status
Project 1
Project 2
Project 3
Project 4
Project 5
Project 6
Project 7
The summary page would be on the Request PMT status tab. On each of the Project tabs there is a table that has this information:
INVOICE # | AMOUNT | CYCLE | DATE SENT TO PAA | PAYMENT AMOUNT | WORK PERFORMED | REASON FOR REVISION | TOTALS | PHASE |
If there is a $0.00 amount in any of the tables I would like it to copy the information to the request pmt status worksheet. I would want it to pull the following information:
Invoice # - Amount - Cycle - PMT Amount.
Side Note: This is my test workbook. Eventually I will have a workbook that will need to pull from about 100-150 projects (each on their own worksheet) so ideally this would need to be able to be utilized for a large quantity of data.
Any advice on how I could achieve my desired results would be much appreciated.