Forum Discussion
If order number matches a cell on the Indexing Sheet, display name on the Filled Orders sheet
ALLENCANADA The Data Drop wasn't so bad after all, although I don't like the merged cells.
Since you are an MS365 subscriber and intend to also use this on the web, I believe you can get rid of the indexing sheet altogether and make use of modern dynamic array functions, some named ranges and a filter on the Filled Orders sheet. Please see attached and let me know if you can work with this.
Note that I changed the order of the columns in the Filled Order sheet to make it easier. One single formula in B2 now fills the table dynamically.
=FILTER(FILTER(dataDrop,oredrType="N1:Sold Order"),selected)And a simple XLOOKUP fills in the Client name.
On top of that, the file size reduced from 5.6MB to 36KB.
Hopefully, this will "unhurt" your brain. Have a good week-end!
ALLENCANADA The Data Drop wasn't so bad after all, although I don't like the merged cells.
Since you are an MS365 subscriber and intend to also use this on the web, I believe you can get rid of the indexing sheet altogether and make use of modern dynamic array functions, some named ranges and a filter on the Filled Orders sheet. Please see attached and let me know if you can work with this.
Note that I changed the order of the columns in the Filled Order sheet to make it easier. One single formula in B2 now fills the table dynamically.
=FILTER(FILTER(dataDrop,oredrType="N1:Sold Order"),selected)And a simple XLOOKUP fills in the Client name.
On top of that, the file size reduced from 5.6MB to 36KB.
Hopefully, this will "unhurt" your brain. Have a good week-end!
ALLENCANADA It will, but you have to make sure that the name ranges that I called "dataDrop" and "ordrType" (sorry for the type there) are updated correctly if the data range expands.
But give a try. Update some records in the Data Drop and Order Entry sheets manually to convince yourself that it works.
- Well, isn't that nifty... Does the filled orders eta data containers dynamically adjust as more items match the criteria from the data drop or is it capped at the 51 lines?