On Jun 18, 2:00*pm, Len <ltong2000...@yahoo.co.uk> 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 * * * * * * * * * * * * * * ColA 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
|
Similar Threads
