Spreadsheet
- or -
Post a project like this2049
$$
- Posted:
- Proposals: 2
- Remote
- #2110522
- Awarded
Description
Experience Level: Intermediate
Please see enclosed 3 documents I need to work on
Fixes :
1. The high level Gantt has some VBA that’s failing. Ideally , when you copy and paste into info tab the Gantt should move based on the dates on the sheet which is not doing so just now. This requires to be fixed.
2. Interface Matrix Programme when you copy and paste new date ( month on month) for unknown reason column J shows error message. Also if you scroll down from line 179, I’ll like column H to have be link to a formula in a way that once ID as above F & H, and those ID’s are part of the data in P6 sheet, the dates populates automatically as the case above.
3. Same for line 123 – 124 ‘ inter matrix’ sheet I’ll like dates to be populated once there’s identifiable H data on the P6 tab to match
***** will like any sheet that data needs to be pasted to be WBS recognized with colours.
New:
1. Attach is the snapshort of the of a level Programme I want a similar Gantt chart like the one I sent for fix and want it work in a way that if I dump the data on a sheet it shows Gantt using the details start/finish and BL1 Start/Finish to generate graph.
Fixes :
1. The high level Gantt has some VBA that’s failing. Ideally , when you copy and paste into info tab the Gantt should move based on the dates on the sheet which is not doing so just now. This requires to be fixed.
2. Interface Matrix Programme when you copy and paste new date ( month on month) for unknown reason column J shows error message. Also if you scroll down from line 179, I’ll like column H to have be link to a formula in a way that once ID as above F & H, and those ID’s are part of the data in P6 sheet, the dates populates automatically as the case above.
3. Same for line 123 – 124 ‘ inter matrix’ sheet I’ll like dates to be populated once there’s identifiable H data on the P6 tab to match
***** will like any sheet that data needs to be pasted to be WBS recognized with colours.
New:
1. Attach is the snapshort of the of a level Programme I want a similar Gantt chart like the one I sent for fix and want it work in a way that if I dump the data on a sheet it shows Gantt using the details start/finish and BL1 Start/Finish to generate graph.
Victor A.
100% (12)Projects Completed
9
Freelancers worked with
8
Projects awarded
59%
Last project
30 Jun 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies