i_know_it_can_be_done said:
I made some minor adjustments as i mentioned previously -
and it worked beautifully!
Thank you so much - very very helpful!
I cannot thank you enough....
Glad to hear that!
And thanks for the feedback
but .. you should always post back in the same thread
FWIW, I've just posted the reply below
to your 2nd post in that thread ..
-------
Subject:
Re: Move Cell Value in Row 2 to Match Location in Row 1
-----------
Ok, with the specifics given, try the revised steps
& revised / extended formula below:
In Sheet1
---------
Select B2:U2
Put in the *formula bar*:
=IF(Sheet2!B2=$B$1:$U$1,Sheet2!B2,IF(Sheet2!
C2=$B$1:$U$1,Sheet2!C2,IF(Sheet2!D2=$B$1:$U$1,Sheet2!D2,IF
(Sheet2!E2=$B$1:$U$1,Sheet2!E2,IF(Sheet2!
F2=$B$1:$U$1,Sheet2!F2,IF(Sheet2!G2=$B$1:$U$1,Sheet2!
G2,""))))))
Array-enter the formula,
viz.: CTRL + SHIFT + ENTER (as before)
This will enter the formula into B2:U2
(which does it for the numbers in row2)
Ensure B2:U2 is selected
Drag the fill handle at
the lower right-corner* of U2
down as many rows as you have source data in Sheet2
*point the cursor at this corner,
it will turn into a black cross
The array formula *should* fill
correctly as you drag down
--
To remove the array formulas,
i.e. freeze/convert to values
Just do an *in-place*
Copy > paste special > check "values" > OK
to overwrite all the formulas with values
Try this:
Select carefully the entire range of the formulas
e.g. select B2:U1000
Right-click on the selection > Copy
Right-click again on the selection (a 2nd time)
Choose Paste special > Check "values" under Paste > OK
That should do it
Drop a line or two here on how it turned out ..
