Writing Macros in MS Project

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3159741%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EWriting%20Macros%20in%20MS%20Project%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3159741%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EHello%20Fellas%2C%20I%20have%20made%20a%20sheet%20comprising%20of%20different%20activities%20in%20execute-serial%20manner%20e.g%3CBR%20%2F%3EActivity%20no%201.%20Create%20excel%20sheets%20(Company%20A)%20finish%20date%202%2F2%2F22%3CBR%20%2F%3EActivity%20no%202.%20Create%20excel%20sheets%20(Company%20B)%20finish%20date%204%2F2%2F22%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20in%20some%20cases%20activity%20from%20Company%20A%20is%20finishing%20first%20like%20in%20above%20example.%20But%20in%20other%20cases%20activity%20from%20Company%20B%20is%20finishing%20first%20and%20Activity%20from%20company%20A%20is%20finishing%20later.%20E.g%3CBR%20%2F%3E%3CBR%20%2F%3EActivity%203.%20Fill%20data%20in%20excel%20sheet%20(Company%20B)%20finish%20date%206%2F2%2F22%3CBR%20%2F%3EActivity%204.%20Fill%20data%20in%20excel%20sheet%20(Company%20A)%20finish%20date%208%2F2%2F22%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20like%20more%20than%201800%20activities%20in%20my%20sheet.%20I%20just%20want%20to%20filter%20activities%20which%20are%20finishing%20later.%20Like%20if%20we%20take%20above%204%20activities%20i%20want%20to%20make%20a%20filter%20which%20can%20filter%20out%20the%20activity%20which%20is%20finishing%20later%20by%20reading%20the%20name%20and%20date%20against%20it.%20Is%20it%20possible%3F%20I%20have%20very%20little%20knowledge%20about%20programming.%20Thats%20why%20i%20am%20not%20able%20to%20write%20a%20code%20which%20can%20perform%20this%20task.%20Seeking%20forward%20to%20any%20help%20at%20this%20forum.%20Thanks%26lt%3B%5C%2Flingo-body%26gt%3B%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor
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 (Company B) finish date 4/2/22

Now in some cases activity from Company A is finishing first like in above example. But in other cases activity from Company B is finishing first and Activity from company A is finishing later. E.g

Activity 3. Fill data in excel sheet (Company B) finish date 6/2/22
Activity 4. Fill data in excel sheet (Company A) finish date 8/2/22

I have like more than 1800 activities in my sheet. I just want to filter activities which are finishing later. Like if we take above 4 activities i want to make a filter which can filter out the activity which is finishing later by reading the name and date against it. Is it possible? I have very little knowledge about programming. Thats why i am not able to write a code which can perform this task. Seeking forward to any help at this forum. Thanks
3 Replies

@Meesam 

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.

2022-02-13_11-05-53.png

Then set up this sort

2022-02-13_11-07-00.png

When applied, this is the result

2022-02-13_11-07-48.png

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)