Hi,
I've attached the Grouping Sample Worksheet...
As you can see, the "Main Data" worksheet is just a alpha llisting..
the "Grouped" worksheet is what I would like to have a macro(VBA script) automatically search for vendor name(s) and group similar names together: such as; all names starting with Accent*, BainP, etc...
I also, manually add a space infront of the group name so that I can sort by alpha order to show grouped names first.
Looking forward to your help :-)
btw: actual pivot table too large to upload (copy/pasted values only)
I'm looking to adjust the following code to select Range by searching for all rows containing certain text and using that as a range to select and rename. Also, can you use * wildcard to search for names containing characters that start with xxx*?
Bookmarks