Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data update
On Jun 18, 2:00*pm, Len wrote:
Hi, There is 2 excel worksheets when new addition of data rows ( ie new row or one cell or more ) or changes of data rows ( ie changes in text of the existing row or cell ) *in worksheet X ( ie source file ) need to update in worksheet Y ( ie target file ). Such new addition or changes of data rows are scatter around the column A only in the entire worksheet X and that new data rows must be inserted at the same row ( ie same location ) of that worksheet X under that corresponding column. After updating new data rows or changes in worksheet Y, the result of worksheet Y with new changes are highlighted in red colour, will be similar with worksheet X . Note there will be no subtraction of data row. I need an Excel VB code or macro to run this process of updating each time when there is a new addition or changes of data rows ( ie text or alphanumeric ) if I pull out these 2 worksheets as it may involve large volume of data rows. With that VB code, preferably user can define or change the column of target file or change the target file for the updating of data changes Example, Wrksheet X * * * *Wrksheet Y * * Col A * * * * * * * * * * * * * * Col A or B or F Row * * * * * * * * * * * * * *Row 1 * * ABC * * * * * * * * 1 * * * BCD-XY 2 * * BCD-XY-01 * 2 * * * EFG 3 * * EFG-00-84 * 3 * * * GHI 4 * * GH * * * * * * * * * * *4 * * * KLJ 5 * * HJI 6 * * 01-KLJ After updating new data rows in worksheet Y, the result of both worksheets will be similar : - Wrksheet Y & X * * * * * Col A Row 1 * * * * ABC 2 * * * * BCD-XY-01 3 * * * * EFG-00-84 4 * * * * GH 5 * * * * HJI 6 * * * * 01-KLJ Can anyone help on this problem, thanks a lot Regards Len Hi, Any helps please, thanks Regards Len |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
update a Pivot Table with new data added to the base data | Excel Discussion (Misc queries) | |||
Update a chart immediately after inputting data into data source | Charts and Charting in Excel | |||
how to update data on sheet1 and have it auto update on sheet2 | Excel Programming | |||
Date update on data update | Excel Programming |