Data update

L

Len

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
 
L

Len

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top