Excel Macro Program [Closed]

Report
Posts
2
Registration date
Friday September 7, 2018
Status
Member
Last seen
September 10, 2018
-
 Blocked Profile -
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.

1 reply

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!

Posts
2
Registration date
Friday September 7, 2018
Status
Member
Last seen
September 10, 2018

Thanks dear. I will check that out. You might be right about database. But if you see i have to use 02 different variables to get a combination of outputs. That too automatically using some program which can process that for me.
Blocked Profile
Dont't worry about the two variables, SQL has language syntax just for that. There are logic built in, like:
LIke X and Y
Like X and NOt like Y
Like X and Y not like Z.
Greater than X but less than z

Have fun!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!