I have a series of formulas in an array of cells.
The formulas look like:
=Snapshot(WK1_Start,$K3,"CRDD")
=Snapshot(WK2_Start,$K3,"CRDD")
etc. Where Snapshot is a UDF that works just fine.
I have 10 weeks across the columns with this formula in Row 3
Next, I copy/paste the formulas across Row 4. The formulas now read:
=Snapshot(WK1_Start,$K4,"CRDD")
=Snapshot(WK2_Start,$K4,"CRDD")
So far, so good.
Now I want to change the formulas in Row 4 to read.
=Snapshot(WK1_Start,$K4,"ABCD")
=Snapshot(WK2_Start,$K4,"ABCD")
I highlight the formulas in row 4 and Click on CTRL-H.
I fill in CRDD in Find What
and ABCD in Replace with.
I click Replace All and it tells me there is nothing to find.
P.S. I found a way to desensitize the data. I want to "Clone" the table with CRDD and populate the table for metric ABCD.
Bookmarks