Excel Macro Program Closed

Question

Dear friends and experts. Greetings for the day !!!
Can someone please share with me some ideas on my problem on Excel VB.
Thanks in advance for your time.

I have two main variables. 1. Project Start Date ( according to which the hours spread must move back and forth on a timeline ) and 2. Project Scope ( according to the variation in project scope which is hours, the value of spread will vary )

Note : Number of projects can be as large as 100 and Scope of work can vary also.
Distribution of hours as you might see will follow a fixed proportionate pattern always.

Do we have some tips tricks how to do this using excel VB.

Example :
Project Start Date Project Scope  JAN  FEB  MAR   APR   MAY  JUNE  JULY   AUG   SEP  OCT
01.04.2018             5000                                               1000  2000  1000   1000 
01.06.2018           10000                                                                      2000  4000  2000  2000

 Thanks in advance for any help.

Best Regards
Have a nice day.

ac3mark · Answer

Do what?  You have described the environment well, but you have failed to let us in on what you are trying to do!

If you are keeping track of work, you need a Database, not a spreadsheet.  Spreadsheets calculate complex math equations!  A database keeps data in an index for analysis.  A database can also do complex math!  A database can provide with reports for specific projects.  A database can provide analytics on employee utilization and such!

If you are willing to try to learn VBA and Excel, it is worth your time to understand a database.  The learning curve is not as steep, and it will provide much more value, turn key!  No programming languages needed (besides SQL).  The database will have wizards to assist with the SQL portions!

Give that a try!

Excel Macro Program

1 response

Subscribe To Our Newsletter!