Macro - filling a workbook form with data in another workbook

Closed
Report
-
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