Hello Excel Wizards,
I am trying to write an If Then statement in VBA to have my workbook save in the appropriate file location depending on the cell value of another open workbook.
I have 2 open workbooks. The one workbook (call it "Wbk A") I am saving has to reference the cell value in the...