Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Posts: 118
Default how to copy and paste value from one sheet to another

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.
Attached Files
File Type: zip Copy of INDEX-160314.zip (7.4 KB, 56 views)
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default how to copy and paste value from one sheet to another

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
  #3   Report Post  
Senior Member
 
Posts: 118
Default

Quote:
Originally Posted by Claus Busch View Post
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
thanks for the reply. but the result is erraneous. in all the columns from B2 in target i get 99 which is the value of B4 of the sheet source.

Last edited by sumesh56 : March 17th 14 at 05:37 AM
  #4   Report Post  
Senior Member
 
Posts: 118
Default

Quote:
Originally Posted by sumesh56 View Post
thanks for the reply. but the result is erraneous. in all the columns 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 99 is displayed, the formula is shown there. then when i click on anywhere else, i get the correct value on c2. i get the correct value in all other cells from d2:d4 by doing this excersise(first double click on the cell then somewhere outside the cell and i get the correct value(total value).99,101,103 etc
  #5   Report Post  
Senior Member
 
Posts: 118
Default

Quote:
Originally Posted by sumesh56 View Post
thanks for the reply. but the result is erraneous. in all the columns 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 in cells other than the one specified in the formula($A2). now i found out the mistake.thanks a lot for the help. have a nice day.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Paste from Class Sheet to Filtered List on Combined Sheet [email protected] Excel Programming 6 September 16th 08 04:30 PM
Help to code Macro to Copy fron one sheet and paste in other sheet kay Excel Programming 3 July 25th 08 06:46 PM
Copy from one Sheet and paste on another sheet based on condition Prem Excel Discussion (Misc queries) 2 December 24th 07 06:05 AM
Active Cell Copy And Paste Sheet to Sheet A.R.J Allan Jefferys New Users to Excel 4 May 4th 06 02:04 AM
automatic copy and paste from sheet to sheet in a workbook ramseyjramseyj Excel Programming 6 December 11th 04 01:37 AM


All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"