LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default Copy from sheet and paste to last row used

Hello,
this is what I'm trying to accomplish:
I want to copy the Total from two sheets and paste into
another sheet below its Total. Example,
Col A B C D
Tot OEM 5642 14587 5874 Etc (Destination sheet)
BLANK ROW
Tot DIST 4254 2541 1247 (copy from sheet2 pastehere)
BLANK ROW
Grand total 9898 17128 7121 (Copy from sheet3 paste here
I been trying to modify codes from post but cant' seem to
get it to work fine. I'm able to copy and paste but it
paste in wrong place and not at end of the sheet total.
I would do a simple copy and paste but since my
destination total's row might change depending on the data
so need to be able to paste to any row.
Hope I'm clear.
any info please advise would appreciate.
thanks,
Juan
 
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 and Paste from one sheet to another Stockwell43 Excel Discussion (Misc queries) 3 September 23rd 08 08:06 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
Copy Paste to another sheet SallyGirl Excel Worksheet Functions 2 May 10th 07 08:10 PM
Active Cell Copy And Paste Sheet to Sheet A.R.J Allan Jefferys New Users to Excel 4 May 4th 06 02:04 AM
Copy paste to another sheet HrvojeZagi Excel Discussion (Misc queries) 2 April 2nd 05 05:54 PM


All times are GMT +1. The time now is 02:00 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"