Prev: How to get SUMPRODUCT on filtered cells
Next: Copy and Paste from One SS to Another
From: New2Macros on 29 Jan 2010 12:04
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!
From: Dave Peterson on 29 Jan 2010 12:27
Select the range
and Edit|Replace

Seems like a quick way to me.

New2Macros wrote:
>
> 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!

--

Dave Peterson
From: Arvi Laanemets on 29 Jan 2010 12:28
Hi

Select the renge with formulas.
Replace> Find what = "Sheet 1 Original" , Replace with = "Sheet 1 New"
>Replace All


Arvi Laanemets



"New2Macros" <New2Macros(a)discussions.microsoft.com> wrote in message
news:C48862BF-AEEA-492A-8078-71D746F7274D(a)microsoft.com...
>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!


 | 
Pages: 1
Prev: How to get SUMPRODUCT on filtered cells
Next: Copy and Paste from One SS to Another