OK, so I have a specific requirement, but not sure how to write the VBA:


1. The user will open a workbook titled "Generator.xls" that contains a [Create] button.
2. When clicked, the user is given the option the browse .xls files on their computer.
3. The user will select the file they want to open.
4. If (on the workbook opened at step 3) a cell in column A = "Data" AND the corresponding cell in column B = "Open", I want to copy the corresponding cell in column C, and paste the value into the next available cell in Column A, Sheet1, "Generator.xls" workbook.


I want this to repeat until all values have been pasted.