JABWootton
Board Regular
- Joined
- Dec 16, 2004
- Messages
- 94
- Office Version
- 2019
- Platform
- Windows
I am attempting to write a macro for the following
I have a list of date in various cells which are updated daily
A sort needs to be done in each worksheet where a certain person is in charge of various projects.
I can do it manually by selecting the data and doing a sort by name or I can create a simple macro where it does this for me.
As the names change monthly this is becoming time consuming as I need to change the macro to show the new persons name
What I need to do is create a macro where that persons name is entered into a cell in a separate worksheet, the macro is the run and the results are sorted in the relevant worksheet.
Any questions please feel free to ask
Thanks in Advance
I have a list of date in various cells which are updated daily
A sort needs to be done in each worksheet where a certain person is in charge of various projects.
I can do it manually by selecting the data and doing a sort by name or I can create a simple macro where it does this for me.
As the names change monthly this is becoming time consuming as I need to change the macro to show the new persons name
What I need to do is create a macro where that persons name is entered into a cell in a separate worksheet, the macro is the run and the results are sorted in the relevant worksheet.
Any questions please feel free to ask
Thanks in Advance