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)
