I am trying to find some code that will allow me to move data from one sheet to another based on criteria.
Ex.) If the row has the word "claimed" in it, I want the values in columns BB-BG to get moved to the new sheet, NOT the entire row. Ideally, the code will make each row in the new sheet look like this: first cell would be the name of the asset, second cell: "claimed", followed by the values from BB-BG in the old sheet.
Additionally, the biggest challenge may be that I have multiple criteria/labels and want the new sheet to group them together, so "claimed" assets will appear first, followed by "unclaimed", "pending", etc. Every criteria/label has the same columns fyi (BB-BG). I want the code to be able to automatically populate any new entries that I put in the old sheet under the correct area in the new sheet.
Any help at all would be greatly appreciated, I have been stressing about this!
- Jexcel
Ex.) If the row has the word "claimed" in it, I want the values in columns BB-BG to get moved to the new sheet, NOT the entire row. Ideally, the code will make each row in the new sheet look like this: first cell would be the name of the asset, second cell: "claimed", followed by the values from BB-BG in the old sheet.
Additionally, the biggest challenge may be that I have multiple criteria/labels and want the new sheet to group them together, so "claimed" assets will appear first, followed by "unclaimed", "pending", etc. Every criteria/label has the same columns fyi (BB-BG). I want the code to be able to automatically populate any new entries that I put in the old sheet under the correct area in the new sheet.
Any help at all would be greatly appreciated, I have been stressing about this!
- Jexcel
