bishop7262
Board Regular
- Joined
- Jan 9, 2010
- Messages
- 87
Don't know if this is possible but wondering if you could tell me if this can be done with a macro.
I have 2 columns, Trainer and Client
I run a filter and sort by Trainer. Right now I highlight the clients associated with that trainer and copy those clients then go to "[Trainer Name]" Worksheet and paste those clients in Column A Row 10. I was wondering if a macro can be built to bring up a pop up menu and allow me to do what I manually do.
So I can pick which trainer either by button which runs the macro and it automatically pasted those clients in the appropriate worksheet.
So far I have 6 trainers that has 6 worksheets that I manually go through and copy and paste clients. I will try to get some image or use boxnet if it is needed to clarify what I would like to have done
thank you for your help in advance
I have 2 columns, Trainer and Client
I run a filter and sort by Trainer. Right now I highlight the clients associated with that trainer and copy those clients then go to "[Trainer Name]" Worksheet and paste those clients in Column A Row 10. I was wondering if a macro can be built to bring up a pop up menu and allow me to do what I manually do.
So I can pick which trainer either by button which runs the macro and it automatically pasted those clients in the appropriate worksheet.
So far I have 6 trainers that has 6 worksheets that I manually go through and copy and paste clients. I will try to get some image or use boxnet if it is needed to clarify what I would like to have done
thank you for your help in advance