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 |
All times are GMT +1. The time now is 04:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com