|I would love to learn to use VBA and it certainly would be helpful for many of my spreadsheets. However, this specific project would be a huge undertaking and not beneficial for me or my company to try to learn VBA with.|
We have several contracts, and a dozen other forms that are currently in Word format. I do not like to use WORD and my administrative staff is not skilled enough to use it or any other program.
Due to the fact that our 4.5 billion dollar a year company does not want to purchase software for contracts and all back office forms and processes, I have been seeking a way to auto-populate our contracts and forms. Our IT department will also not allow us to have a data base. So I thought I could try to prepare these documents in Excel to help out with this task. The concatenate function appears to work, but there are BOLD items and RED items in our contracts and forms.
My goal was to have a hidden sheet that all data could be entered on and then auto-populate all contracts, as well as the 10 other forms often used for each project. In this manner, the admin staff would not have to page through all of the sheets and different forms. All project data would only have to be entered once and if revised, only need to do it in one place.