LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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, 57 views)
 
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 05: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 12:37 AM


All times are GMT +1. The time now is 10:54 AM.

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

About Us

"It's about Microsoft Excel"