daverosati1785
New Member
- Joined
- May 28, 2020
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
I'm trying to take information filled-out by customers on one Excel sheet (a purchase order) and have it automatically fill-out another spreadsheet (invoice). I'm trying to avoid having to manually fill-out customer invoices by instead linking the spreadsheets together. The issue I'm having is this:
The purchase order spreadsheet basically looks like this:
The customer fills-out the Quantity column for the products they want and leaves it blank for the products they don't. The above is an example.
In turn, in my invoice spreadsheet, I need to generate a similar set of columns that simply skip over the products the customer didn't select. So for instance, my invoice would just look like this:
I need it to pull the information from the first spreadsheet while skipping rows that had a blank cell in the Quantity column. I've been messing around with arrays, the index function, the ifblank function, etc. but can't seem to get it.
Please help!
The purchase order spreadsheet basically looks like this:
Product Name | Price Per Unit | Quantity |
Widget A | $1.00 | 2 |
Widget B | $2.00 | |
Widget C | $3.00 | 1 |
The customer fills-out the Quantity column for the products they want and leaves it blank for the products they don't. The above is an example.
In turn, in my invoice spreadsheet, I need to generate a similar set of columns that simply skip over the products the customer didn't select. So for instance, my invoice would just look like this:
Product Name | Price Per Unit | Quantity |
Widget A | $1.00 | 2 |
Widget C | $3.00 | 1 |
I need it to pull the information from the first spreadsheet while skipping rows that had a blank cell in the Quantity column. I've been messing around with arrays, the index function, the ifblank function, etc. but can't seem to get it.
Please help!