Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rex Rex is offline
external usenet poster
 
Posts: 26
Default adding data to existing data and replacing old one in excel?

adding data to existing data and replacing old one in excel?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default adding data to existing data and replacing old one in excel?

Range("A1").copy

Range("B1").PasteSpecial xlValues, xlAdd

--
Regards,
Tom Ogilvy

"rex" wrote in message
...
adding data to existing data and replacing old one in excel?



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
Adding and then sorting data into an already existing Excel 2007 w courtenaylambert Excel Worksheet Functions 2 March 26th 10 07:25 PM
Imported Data Not Replacing Existing Data - Excel 2007 Marilyn Excel Discussion (Misc queries) 0 April 27th 09 05:22 PM
prevent copied blank cells from replacing existing data lilleke Excel Worksheet Functions 10 August 28th 07 09:26 PM
Adding data to existing data that has a unique number in column Lars Excel Discussion (Misc queries) 3 June 28th 07 11:48 AM
adding data to existing data cell Curious Excel Worksheet Functions 2 January 19th 07 08:21 PM


All times are GMT +1. The time now is 11:23 AM.

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"