Hi Everybody,

Brand new here and really excited to start learning from you guys.

I have a problem I am trying to solve but am not quite adept at Excel VBA just yet to get it to work properly. I found a very similar code online that does what I am aiming for, but I cannot get it to repurpose correctly and operate based on the buttons as I intend.

Essentially my problem is this.

I have a folder with approximately (5) files in a folder that are all created with information based on the first Excel File. I am trying to make a macro in Excel that when whoever presses the button, the code would run and push data from the primary file (Initiation File) and create an LOI and copies of another document for the other two vendors. Details Below.

File 1 Has three company names in cells A1, A2, and A3. Whatever company is in A1, when the button is pressed at the bottom of the page, the information will be pushed to a word document based on the company name, address, etc. that are all elsewhere in the same document. For Companies A2 and A3 another button would be pressed and their information would be pushed to another word template that would reflect their company-specific information then save it all within the same folder. Ideally with the press of these two buttons in the initial document, (3) new word documents with company-specific information would have been made and saved in the same folder. The idea of this is to help cut down on the data entry for me so that when these companies are selected I can press a button and autocreate the forms I need as opposed to digging around and typing the information in as I have been.

Is there anybody proficient with VBA that would be open to helping me solve this problem?