Forum Discussion
Writing Macros in MS Project
Hello Fellas, I have made a sheet comprising of different activities in execute-serial manner e.g Activity no 1. Create excel sheets (Company A) finish date 2/2/22 Activity no 2. Create excel sheets...
Unless I'm missing something, you do not need VBA. Careful structuring of your file with a simple filter and sort should get what you want. Given what you have presented, here is a suggested structure.
Then set up this sort
When applied, this is the result
Does that work for you? If not, why not?
John
Sir, Thank you so much for replying. Actually my sheet is already made. And it has alot of activities like i described. Now as i want to see only those activities which are finishing later. Thats why i want to write a macro which can compare names of 2 activities identifying which one is from company A and which one is from B. After that filtering out the activity which is finishing later. I have alot of files like this. So making it automatic will help me alot.
- Meesam,
It's still not clear that you need a macro to do what you want. However, for me to better understand what you have I'd like to take a look at your file and then decide the best approach. You can send the file to me at the address below. I will ask some questions.
John
jmacprojataticlouddotdotcom
(remove obvious redundancies)
