N
New2Macros
I have a sheet which is looking up data from another sheet, and I want change
that "lookup sheet." How do I do this quickly?
Example: =LOOKUP($A1,'Sheet 1 Original'!B1:B3,'Sheet 1 Original'!C1:C3)
I want to change that "Sheet 1 Original" reference to "Sheet 1 New," in 100
cells at once. Thanks!
that "lookup sheet." How do I do this quickly?
Example: =LOOKUP($A1,'Sheet 1 Original'!B1:B3,'Sheet 1 Original'!C1:C3)
I want to change that "Sheet 1 Original" reference to "Sheet 1 New," in 100
cells at once. Thanks!