Hi all, in the sample file, I have a column of values on Sheet1.
On Sheet 2, I have a column that references the column on Sheet1.
I'm looking for some code that, given the lookup value (in this case AB02, which is on cell Sheet1!B4), would insert in cells Sheet2!B11:B14, the formula =Sheet1!B$4.
All suggestions appreciated. TIA, Paul
Bookmarks