PROJECTS:
-
Split Master Excel into Multiple Sub Workbooks using Sharepoint Links.vba This project allows users to split a master excel into multiple sub workbooks The criterial of splitting the master workbook uses 1 criteria The macro will have to search for existing sub workbook using sharepoint link If it exists Open the workbook Paste the filtered cells into the workbook Save the workbook If it does not exist Add a new workbook Paste the filtered cells into the workbook Saveas the workbook
-
Mail Merge Excel to Word.vba This project allows users to use excel to mail merge values into word document using tagname and tagvalue create tagsname in word document using <> create your excel to look like the attached picture
create a button to run the macro
create a contract row cell for users to indicate which row to run the macro