To answer your first question ... use an if then statement to wrap the equate values command e.g.
Now the row will only be transferred if G2 = 100 ... you can name any rule you want
I would like to be able to use the submit button whether the master workbook is opened or closed
I would do something like the following ...
To use the above code add the following function to the bottom of the module
If you would like to close the destination workbook (after the code has run) if it was previously closed and needed to be opened or do nothing if it was already opened this can be done to. Simply insert a variable declared as Boolean after the Workbooks.open command and set it to true ... something like:
Bookmarks