Hello all you amazing people!
I am really stuck on a piece of VBA code, meaning I have no idea where to start!
What I have is a spreadsheet that can have up to 5,000 lines and 16 columns. In column E is a branch, and what I need to do is get the 3 or 4 matching branches in each of our groups to copy all matching rows into a separate spreadsheet.
Please see attached example. What I need is for a piece of code to look in column E, find all rows where it says Branch 1, Branch 5 and Branch 9, and copy all of the rows of each three branches into tab A.
I hope this makes sense, thank you in advance!!
Bookmarks