Hi,

Am Sun, 16 Mar 2014 17:12:16 +0000 schrieb sumesh56:

I have basic values in sheet named SOURCE
i have aggregate values in sheet named TARGET
The values shown in B4:D4 in sheet SOURCE is an outcome of a formula.I
want this values to be copied to B2:D2 in sheet named TARGET
likewise the values shown in B8:D8 in sheet SOURCE to be copied to B3:B3
in sheet TARGET. Likewise the data in B20:D20 to be copied
i can do this manually by copy and paste special-values.

in B2 of TARGET:
=VLOOKUP($A2,source!$A$1:$D$20,COLUMN(),0)
and copy to right and down.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2