Thanks for checking this post!
As stated, I'm creating a Purchase Order packet (Excel 2016), which generates a printable Requisitions and POs, and allows fields for delivery and invoice tracking. On the entry sheet (PO Long Form), I've created a table from columns A$-G$, which will contain the individual PO line items (Line#, QTY, UOM, Part#, Description, Unit $, Extended $); column G holds a simple formula (F$*B$) to calculate Ext $ (column G).
I've created a child sheet (PO) which takes some of the entry data and auto-plugs it in (=('PO Long Form'![cell]) or the like) to enter in supplier, address, etc. This works fine.
However, in the PO itself I'm trying to have the table data update the cells in which the line items need to go. EX: D20-J20 will (hopefully) display any line items entered in the table range above (A$-G$), and stop when no more data is present. So, if I have three line items, it will fill D(20-22)-J(20-22). I have formulas at the bottom to SUM the Subtotal, Tax, Shipping into a TOTAL. If there are 20 line items, D(20-39)-J(20-39). And so on ...
Without going into the tedious details of describing all the ways I've done it WRONG, are there any suggestions out there on how to do this RIGHT?
Any and all help is greatly appreciated! Thanks in advance.
Bookmarks