Hi,
I'm attempting to create a random cycle count generator and I have the foundation of it working correctly (taken from this thread Random Cycle Count Generator). However, I'm wanting to take it one step further and create a count sheet that pulls in all the items that are currently warehoused in the randomly selected locations.
The random location generator adds 1 column each time the macro is run. In theory this would let me track all the locations counted over a period of time to ensure we capture everything.
(CC QUERY)
The next step is a dynamic filter using the selected to Locations to pull On Hand Inventory from a report into this table.
How do I make this filter use the last column added to the first image. I would like it to pull in the last column with data.
=FILTER('OH Inventory'!B:H,ISNUMBER(MATCH('OH Inventory'!B:B,'CC Query'!B:B,0)),"No Results Found"). I think I just need the 'CC Query'!B:B to grab the last column instead. Any help or suggestions are apprectiated.
Thanks.
I'm attempting to create a random cycle count generator and I have the foundation of it working correctly (taken from this thread Random Cycle Count Generator). However, I'm wanting to take it one step further and create a count sheet that pulls in all the items that are currently warehoused in the randomly selected locations.
The random location generator adds 1 column each time the macro is run. In theory this would let me track all the locations counted over a period of time to ensure we capture everything.
(CC QUERY)
The next step is a dynamic filter using the selected to Locations to pull On Hand Inventory from a report into this table.
How do I make this filter use the last column added to the first image. I would like it to pull in the last column with data.
=FILTER('OH Inventory'!B:H,ISNUMBER(MATCH('OH Inventory'!B:B,'CC Query'!B:B,0)),"No Results Found"). I think I just need the 'CC Query'!B:B to grab the last column instead. Any help or suggestions are apprectiated.
Thanks.
