Hi there, i'm looking for some help with a macro. I have 2 workbooks, one is a form with several cells that need to be filled out (FORM.xlsx) and the other is a master list (MASTER.xlsx) that contains all of the data used to that is needed for the form.
I need to search through the master for any row where column AA = "FillForm", then i need to copy data from MASTER B# --> FORM C6; MASTER F# --> FORM C8 and MASTER H# --> FORM C10.
I then need to "save as" the FORM.xlsx to with the name "FORM A#.xlsx
Where # is the row number.
I am useless at VBA, so any help would be appreciated
Macro - filling a workbook form with data in another workbook