Worksheet data

[visible]

Hi,

In an Excel file, there are two sheets:-

1. Original
2. ImportedData

I am not allowed to change entire contents of Sheet(1), unless to add a unique and new row from Sheet(2) or vice-versa.

I am allowed to comment on contents of Sheet(1) or Sheet (2) in Column J only on basis of Col A, B and D.

Following comments are applicable: -

Duplicate,
Old,
New,
Updated or
Attached

Lets Imagine that Column J of both worksheets do not exist.

Based on either worksheet, We have to update values in Column J of both worksheets through VBA.

Priority (in order) to update sheets:-

ImportedData {which is Sheets(2)}
Original {which is Sheets(1)

It would mean that we have to start filling J Col of ImportedData Sheet first.

Following definitions apply:

Duplicate: Those duplicate values in Col A, B and D of Sheets(2)
Old: Those values which are same in Col A, B and D of Sheets(1) and Sheets(2).
New: Those values in Col A, B and D of Sheets(2) which does not exist in Sheets(1)
Updated: Those values in Col A, B and D of Sheets(2) which does not exist in Sheets(1) and were updated in Sheets(1) using data from Sheets(2).
Attached: Those values in Col A, B and D of Sheets(1) which does not exist in Sheets(2) and were attached in Sheets(2) using data from Sheets(1).

we call same row as "updated" in Sheets(1) , while we call it as "New" in Sheets(2).

 

[bensonsearch]

Hi and welcome.

Sorry I seem to be confused, is there a question here?

 

[visible]

Hi and welcome,

How can I comment on contents of Sheet(1) or Sheet (2) in Column J only on basis of Col A, B and D through VBA?