Here's my problem. I have a spreadsheet with two worksheets. On sheet2, in cell B4 I have a value. I need to get that value and then locate the last instance of that value in column A on sheet1 and then copy the row it appears in to sheet2, row 10. What's the most economical way to code this as a macro?