I need a macro to sort through the data I have and display only certain groups.
For example I need all the data that comes from a group with an A suffix
Desktop.PNG
I need a macro to sort through the data I have and display only certain groups.
For example I need all the data that comes from a group with an A suffix
Desktop.PNG
I'd build a macro that:
- Found the bottom row of the data
- Started a search from the top row to the bottom row
- Each time I hit a value in column A, I would see if the Right(colA.value,1) ="A" I would write it to another sheet.
- If the next value was blank and had a value in colB then I would write to the sheet.
In the end you would have a sheet full of _A values.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks