Hi Community,
I am pretty new to VBA , most things I do are formulas and functions. I hope you can help.
Basically I have 1 sheet (masterschedule) which can have a name in two different columns. I need to be able to find the name, whether in column F or I and copy the row associated with it on a second sheet (schedule by team). I would like it to copy each time I enact the VBA, So that it would include any updates I do to the masterschedule such as scores.
On the second sheet, If it could tee off of the name that would be ideal
I attached one I did manually to show what I am hoping it would look like. But I am not stuck on the format. I just need to see each together.
Bookmarks