I am trying to auto populate data from a cell in one sheet to another cell in
another cell in a different spreadsheet in the same book and cannot figure
out how to do it in Excel 2007.