Looking to get some macro coding for:
Macro will search a row for a "x" (x is a =if(today(),"x","")
when it finds the x it will then look down the coloumn and find any empty cell down to 300 and copy each coloumns.row (a:b) and paste it into another sheet
I would also like it to search only for 2 different names in those coloumns and only copy them so it may only copy 50ish.
eg
a---b--------c d e-----f g h i j
________________________
-------------------x
1---Name
2---Name-----Away
3---Name-----Away
4---Name
5---Name
300
-1 should be copied because it empty but only want to copy 4 and 5. Wont copy the "Away" rows!
This is what i want to see come from it:
4---Name
5---Name
Thanks
(Eg didnt quick work the way i wanted sorry)
Bookmarks