Log In
Register
Home
Active Member
December 18, 2020
Offline
Thanks in advance for any help or ideas for improving this workbook!
All information is geared from the "unit types tab".
My specific request for help is on the "PO" tabs and this formula which is used in the "bordered" section: =INDEX($A$2:$A$78,MATCH(0,INDEX(COUNTIF($E$18:E20,$A$2:$A$78),0,0),0))&(IF(COUNTBLANK($A$2:$A$78),""))
The Index is pulled in from the corresponding tab, in the order that the information is entered into each column on that tab (Column A first, then B, C, etc) . Once the Index information is pulled into the "PO" "printable - bordered" section and combined to one listing/number - is there a way to re-order so that like items would be listed in the same area instead of in the order of the columns on the corresponding tab? For example, I would like all drywall board to appear in the same area of the PO instead of having two or three board types appear 3/4 of the way down the page.
I'm open to any suggestions to improve this workbook!
Respectfully, Julie
VIP
Trusted Members
December 7, 2016
Offline
Hello Julie,
No workbook attached. After selecting/adding the file to upload you need to click the Start Upload button.
Br,
Anders
Active Member
December 18, 2020
Offline
Thank you Mr. Sehlstedt! I have attached the file.
VIP
Trusted Members
December 7, 2016
Offline
Hello Julie,
Your file contains lots of data and I have not yet fully understood what is happening in the file. I take it that it is kind of an inventory list with purchase orders. With current layout all your lists/tables are static, if you can arrange the data so you can use Pivot Tables to build your "bordered" section you will get dynamic lists without using cumbersome INDEX & MATCH formulas.
In order to get the items of same category listed after each other then you either need to sort your data in the list accordingly or add such category data in your lists. Without Pivot Tables you then also need to add such subheaders in your bordered section. See attached for an example using Pivot Table.
Br,
Anders
1 Guest(s)
