i want to copy paste the values from one sheet to another

I have basic values in sheet named 'Basic"

i have aggregate values in sheet named "Aggregate"

The values shown in B5:D5 in sheet basic is an outcome of a formula.I want this values to be copied to E3:G3 in sheet named aggregate.

likewise the values shown in B11:D11 in sheet Basic to be copied to E4:G4 in sheet aggregate.

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.

Use:

Formula:

Please Login or Register  to view this content.

Watch about $'s and make sure months are always same and in same order.
Meaning they must be one cell next to it as in Basic sheet.

thanks for the quick replies. i will check and inform the result. have a nice day.

Originally Posted by sktneer

Also.....

In E3 of Aggregate sheet

Please Login or Register  to view this content.

and copy across and down.

just now i have checked it. it works as i wished.i dont have deep knowledge about the codes. but can you find time to explain the second part of the code which starts from $A3,...... you have given the absolute cell reference of A3 and the range being quoted as A3:A11. whereas i have data to be copied to in B5:D5 and B11:D11.

Originally Posted by sktneer

Also.....

In E3 of Aggregate sheet

Please Login or Register  to view this content.

and copy across and down.

just now i have checked it. it works as i wished.i dont have deep knowledge about the codes. but can you find time to explain the second part of the code which starts from $A3,...... you have given the absolute cell reference of A3 and the range being quoted as A3:A11. whereas i have data to be copied to in B5:D5 and B11:D11.

=IFERROR (INDEX(BASIC!B$3:B$11,MATCH($A3,BASIC!$A$3:$A$11,0)),"'')
when i copy pasted the formula from this site and applied on the excel it worked, but when i reentered the formula but it does not work. what has happened? a dollar sign on the left of the cell address shows that it is absolute cell reference($A$2) . but when the dollar sign is USED ONLY ONCE as in ($A2,B$2) what should it be called?

Originally Posted by sumesh56

=IFERROR (INDEX(BASIC!B$3:B$11,MATCH($A3,BASIC!$A$3:$A$11,0)),"'')
when i copy pasted the formula from this site and applied on the excel it worked, but when i reentered the formula but it does not work. what has happened? a dollar sign on the left of the cell address shows that it is absolute cell reference($A$2) . but when the dollar sign is USED ONLY ONCE as in ($A2,B$2) what should it be called?

i got it. $A1=Col A1 is locked(mixed cell reference). A$1=Row one is locked $A$3=absolute cell reference =Col and row are locked.

Originally Posted by zbor

Use:

Formula:

Please Login or Register  to view this content.

Watch about $'s and make sure months are always same and in same order.
Meaning they must be one cell next to it as in Basic sheet.

your formula works fine when applied to the file attached. But i want to apply this formula in a new sitauation. i changed some of the content to suit to the situation. but it doesnot give the required result. i applied the formula to clee c1 of sheet named target. it gives all the primary details also. kindly correct me. thanks. the sample file is attached.

Originally Posted by FDibbins

try this, copied down and across...
=INDEX(BASIC!$B$3:$D$11,MATCH(AGGREGATE!$A3,BASIC!$A$3:$A$11,0),MATCH(AGGREGATE!E$2,BASIC!$B$2:$D$2,0))

Your formula worked on the initialy posted excel file. but i tried to apply it in a new situation and it does not work. kindly help. i have applied the formula on D20 of the target sheet.see attachment please.

Originally Posted by zbor

Use:

Formula:

Please Login or Register  to view this content.

Watch about $'s and make sure months are always same and in same order.
Meaning they must be one cell next to it as in Basic sheet.

zbor,

I have tried your formula in a number of files and i got the result also. but one alarming thing. when i take the aggregate sheet from my computer and put in another one it shows unrecognised characters as if it lost the linked file(Basic). how to overcome this issue? what i want to know is how can i get the result independant of the basic file. one solution i did is prepared the same sheet template ,copy the whole content , and pasted to the new template! doing this in many sheets-indeed tiresome.kindly help by giving me directions. thanks

Originally Posted by zbor

Use:

Formula:

Please Login or Register  to view this content.

Watch about $'s and make sure months are always same and in same order.
Meaning they must be one cell next to it as in Basic sheet.

zdor,

I have tried your formula in a number of files and i got the result also. but one alarming thing. when i take the aggregate sheet from my computer and put in another one it shows unrecognised characters as if it lost the linked file(Basic). how to overcome this issue? what i want to know is how can i get the result independant of the basic file. one solution i did is prepared the same sheet template ,copy the whole content , and pasted to the new template! doing this in many sheets-indeed tiresome.kindly help by giving me directions. thanks