EnderLexus
New Member
- Joined
- Nov 20, 2023
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
Hi there,
Slightly difficult to explain, but I have a sheet which I use to keep track of inventory thats coming in/out. I've built an excel sheet, and have finally decided to ask for help in one part that annoys me :D
I don't believe is fully relevant but for context, the start of the sheet uses a basic collection to link item numbers I put in to their products, then if they don't match it will automatically tag as NOT FOUND
Some products won't match up which is expected, so I'm trying to see if there is a way after I do a sort to move the rows that say not found to the NOT INCLUDED table? My only issue is, sometimes there are 1/2 and other times there can be 10 so its that variation where I'm not sure how to program that as a macro. I have tried and failed to do it as a recorded macro, but that might just be me
So below is a view, after performing a collection, then sorting the cells
Ideally, a macro which can just assign to a button above to create something like below, rather than going through manually.
If anyone is able to help would be much appreciated
Slightly difficult to explain, but I have a sheet which I use to keep track of inventory thats coming in/out. I've built an excel sheet, and have finally decided to ask for help in one part that annoys me :D
I don't believe is fully relevant but for context, the start of the sheet uses a basic collection to link item numbers I put in to their products, then if they don't match it will automatically tag as NOT FOUND
Some products won't match up which is expected, so I'm trying to see if there is a way after I do a sort to move the rows that say not found to the NOT INCLUDED table? My only issue is, sometimes there are 1/2 and other times there can be 10 so its that variation where I'm not sure how to program that as a macro. I have tried and failed to do it as a recorded macro, but that might just be me
So below is a view, after performing a collection, then sorting the cells
Ideally, a macro which can just assign to a button above to create something like below, rather than going through manually.
If anyone is able to help would be much appreciated
