Mirror only one column across sheets

My requirement is as follows

I have Sheet1 in which Col. A are "Room names". I want Col. A as “Room names” in Sheet2. The other columns B, C, D in Sheet1 and Sheet2 are unique as per my requirement. Any addition or deletion of row / addition of any text to Col. A in Sheet1 should be reflected in Sheet2.

When new row is included in between any row of Sheet1, it should insert a new row between the corresponding rows in Sheet2 also (i.e. the data in Col, B, C, D Sheet2 should also shift by one row). The requirement is illustrated in the diagram.

I found a problem similar to mine
https://productforums.google.com/for...cs/8kHkkZYd4vg and I even tried the A1: =SORT(Sheet1!A:A, 1, TRUE), but to no avail.

I modified the code found here https://stackoverflow.com/questions/...-with-automati

Bu, the problem I am facing is that, it mirrors the entire table in Sheet1 to Sheet2. As explained in the preceeding paragraph, I require only Col. A to be mirrored to Sheet2 with the condition that any addition or deletion of row in Sheet1 to be reflected in Sheet2, with corresponding offset of rows in Sheet2 also.

Please Login or Register  to view this content.

Please help modify this code .

Image and excel workbook attached

(NOTE:

In the figure, Row 4, 5, 7 have been added later in Sheet1. This additions of row should also be inserted in Sheet2 with the data below the added rows shifted downwards. If any data is entered in A4 of Sheet1 now, it should also be reflected in Sheet2, but other columns should be independent as the other fields in Sheet1 and Sheet2 are unique)

You can do without vba.
select column "A" in sheet1 > copy "A" column (As per your data record) > click on "Camera" Tab > & paste into sheet2.
If Camera tab not showing in toolbar, then click on office button > click on "excel option" > click on "Customize" > select "All command" > select "Camera" > click on "Add" > click on"ok"

I tried this and felt not a satisfactory solution. It is just as taking a screenshot of column A. When I insert new row in Col. A of Sheet1, the corresponding rows are also not shifted in Sheet2. Could you please help modify the code?

Note: Only Col. A in both sheets are required to be same. Other cols. are unique as shown in the figure


I came across a problem same as that of mine here

https://superuser.com/questions/6301...-in-excel-2010

The array formula used here achieves the objective of mirroring Col. A to Sheet2, but does not address the shifting of corresponding rows in Sheet2 when new row is added to Sheet1.