Date and Cost Calculator in MS Word, Excel
Budget: $30 – $250 USD
I need someone who has extensive visual basic programming in MS Office.
I have a word document that contain all of my templates. Each template has a base date and one or more other dates which are calculated off of the base date. For example, the base date is 1/31/21 and there may be one more date fields one month out which would be 2/28/21 or 2/29/21 if it is a leap year. The additional date fields will have different calculations. for example, it might be 2 or 3 months from the base date. it might be 6 months from the base date minus 14 days. I would like to be able to enter the base date and have the other dates auto calculated and inserted into their proper field(s).
In that same word document, there is common data that is inserted. For example, the common data might be name of client, serial number, etc. This common data is associated with a reference number. I would like the common data to be stored in an excel spreadsheet which the user can enter information. After updating the excel spreadsheet, the user should be able to go into the word document and enter in the reference number. The macro should retrieve the common data from the excel spreadsheet then insert it into the proper fields.
I have a word document that contain all of my templates. Each template has a base date and one or more other dates which are calculated off of the base date. For example, the base date is 1/31/21 and there may be one more date fields one month out which would be 2/28/21 or 2/29/21 if it is a leap year. The additional date fields will have different calculations. for example, it might be 2 or 3 months from the base date. it might be 6 months from the base date minus 14 days. I would like to be able to enter the base date and have the other dates auto calculated and inserted into their proper field(s).
In that same word document, there is common data that is inserted. For example, the common data might be name of client, serial number, etc. This common data is associated with a reference number. I would like the common data to be stored in an excel spreadsheet which the user can enter information. After updating the excel spreadsheet, the user should be able to go into the word document and enter in the reference number. The macro should retrieve the common data from the excel spreadsheet then insert it into the proper fields.