Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
updating of data without overwriting the previous data updated
what codes should i add if i want to copy several number of files into
table without the data overwriting the previous data that is bein updated?the following are the codes so far for inporting th data,thanks..: 'perform input Set TargetRange = Range(TargetAddress).Cells(1, 1) Set SourceRange SourceWB.Worksheets(SourceSheet).Range(SourceAddre ss) For A = 1 To SourceRange.Areas.Count SourceRange.Areas(A).Copy If SourceRange.Areas.Count 1 Then Set TargetRange = _ TargetRange.Offset(TargetRange.Areas(A).Rows.Count , 0) End If If PasteValuesOnly Then TargetRange.PasteSpecial xlPasteValues TargetRange.PasteSpecial xlPasteFormats Else TargetRange.PasteSpecial xlPasteAll End If Application.CutCopyMode = False Next -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent previous entered data from updating | Excel Discussion (Misc queries) | |||
How copy none excel data & paste in 2007 without overwriting data | Excel Discussion (Misc queries) | |||
Overwriting data in other worksheets while updating another | Excel Discussion (Misc queries) | |||
updating cell data and keep from overwriting | Excel Worksheet Functions | |||
Updating a textbox without erasing previous data | Excel Programming |