how to copy and paste value from one sheet to another

[sumesh56]

I have basic values in sheet named SOURCE
i have aggregate values in sheet named TARGET
The values shown in B44 in sheet SOURCE is an outcome of a formula.
want this values to be copied to B22 in sheet named TARGET
likewise the values shown in B88 in sheet SOURCE to be copied to B3:B
in sheet TARGET. Likewise the data in B2020 to be copied
i can do this manually by copy and paste special-values.
But is there any way to done it automatically by excel? thanks
the sample file is attached

+-------------------------------------------------------------------
|Filename: Copy of INDEX-160314.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=950
+-------------------------------------------------------------------

 

[Claus Busch]

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 B44 in sheet SOURCE is an outcome of a formula.I
want this values to be copied to B22 in sheet named TARGET
likewise the values shown in B88 in sheet SOURCE to be copied to B3:B3
in sheet TARGET. Likewise the data in B2020 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.

 

[sumesh56]

Hi

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


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


Regard
Claus B

thanks for the reply. but the result is erraneous. in all the column
from B2 in target i get 99 which is the value of B4 of the sheet source

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[sumesh56]

thanks for the reply. but the result is erraneous. in all the column
from B2 in target i get 99 which is the value of B4 of the sheet source.

on further examination i found that when i double click on c2 where 9
is displayed, the formula is shown there. then when i click on anywher
else, i get the correct value on c2. i get the correct value in al
other cells from d2:d4 by doing this excersise(first double click on th
cell then somewhere outside the cell and i get the correct value(tota
value).99,101,103 et

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[sumesh56]

thanks for the reply. but the result is erraneous. in all the column
from B2 in target i get 99 which is the value of B4 of the sheet source.

your formula is great . it works. i was wrong in putting the formula i
cells other than the one specified in the formula($A2). now i found ou
the mistake.thanks a lot for the help. have a nice day

+-------------------------------------------------------------------
+-------------------------------------------------------------------