Share
Report
33Hi,
I'm trying to figure out a way to extract the information shown in the screenshot attached. The problem is that a document could have 20/30+ invoices on it. I was considering creating a table for Invoice 1, 2, 3 etc but I dont know if that would work well. I want to pull the information in to a table like the below. I've covered the Schedule# but have included a random number in the table as an example.
What would be the best way to go about this. When i could have 2 or 3 pages of these small invoice summary tables with multiple schedules on each coming through?
| INVOICE # | DATE | SCHEDULE # | DESC | REBAR WEIGHT | REBAR VALUE | MESH WEIGHT | MESH AREA | MESH VALUE | SUNDRY VALUE | DEL CHG | TOTAL |
| 143516 | 27/10/2023 | 1 | ZONE 1 - FIRE STAIR | 10641.6 | $20217.85 | 0.0 | 0.0 | 0 | 0.0 | 600 | $20217.85 |
| 143892 | 9/11/2023 | 2 | ZONE 1 -EASTERN | 7511.2 | $14270.55 | 0.0 | 0.0 | 0 | 0.0 | 600 | $14270.55 |
| 143962 | 9/11/2023 | 3 | SITE REQUEST | 1267.9 | $2400.23 | 0 | 0 | 0 | 0 | 600 | $12400.23 |
| 143962 | 9/11/2023 | 4 | ADDITIONAL | 352.3 | $666.90 | 0 | 0 | 0 | 0 | 600 | $666.90 |
| 143962 | 9/11/2023 | 5 | TOWER CRANE | 5294.9 | $10075.62 | 0 | 0 | 0 | 0 | 600 | $10075.62 |
Categories:
All responses (
Answers (
