how to copy and paste value from one sheet to another

sumesh56

Senior Member

Posts: 118

Quote:

Originally Posted by sumesh56

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 04:24 AM.

Menu

About Us