Yes, I know I can do that. What I want is to pass the value to sheet 2 A1, and get the value from W2 back on sheet 1, which I know is easy. But I don't want to repeat that all the way down the sheet, so on the next row in sheet one, I want that to go to the same sheet 2 A1. See the issue?
|