I've got to worksheets. One (Sheet 1)is based on an aging report, the other (Sheet 2)is connected via ODBC to our server. I would like to have the address fields in Sheet 1 populated conditioned on the account #'s matching. They have no label in sheet 1 and are located in the A Column. They are in Row BF on Sheet 2 and titled CutomerCode. A sample spreadsheet is attached.
Thanks so much for your help.
Bookmarks