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.
But is there any way to done it automatically by excel? thanks
the sample file is attached.