Link to home
Start Free TrialLog in
Avatar of Iryna253

asked on

Update macro in Excel for critical path


Can you please help me to update macro that shows a critical path (x) for the sheet1. I have it working on a sheet2 but I moved it to sheet1 and it is not working looks like.

Also, is it possible to show a critical path on a graph with a different color? So when I change values in "Batch time" column the graph will change and color of critical path will be shown?

Thanks in advance!
Avatar of tel2
Flag of New Zealand image

Hi Iryna,

Is this homework, or what do you need it for exactly?
Avatar of Iryna253


no, this is not for the homework. this is for my work. I already asked help on it before.
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you very much!
How about this one, Iryna?:
Was it homework?
Yes, it was. I resolved it. Sorry for asking, I will not ask this anymore HW questions. Thanks for your help.
Hi again Lryna,

At EE you are allowed to ask for help with homework assignments, but here are the official rules in detail:

A couple of main points are:
a) Make sure you clearly state in your first post that it is an assignment.
b) Don't ask experts to give you the answers.  Ask for guidance so that you can work out the answers yourself.
But you should read & follow all the rules in the links above.

Now, tell me Lryna:
Q1. Are you still getting your formal education?
Q2. What job do you do that requires solutions like this critical path Excel question?

I await your reply with answers to Q! & Q2.

Hello tel2, did yo receive my reply to this massage? I submitted it yesterday but I cannot find it.
All I can see is what is above, Lryna.
Please post your answers to Q1 & Q2 again and make sure they are visible on the page after submission.
Q1: Yes, i am still in school completing my degree this fall while working full time.
Q2: I am doing projects at work to calculate how many people we need if we will increase production. For this purposes I studied Project Management in school using Microsoft Project program, but I would like to use Excel instead. I will source your company in my report for helping me with automation. Will this be ok?
> I will source your company in my report for helping me with automation. Will this be ok?
I wouldn't if I were you, because:

a) I didn't help you with the automation.  It looks as if Ejgil did.
b) I don't have a company.
I will indicate Experts Exchange company in my report.