Hi. I have two sheets in the same workbook. I need a column on the 2nd
sheet to match a column on the 1st sheet. So that when data is entered into
this column on sheet1 it is also entered automatically on sheet2. Is this
possible? I tried to set the column on sheet2 to =Sheet1!A1, but when I
delete/add rows to sheet1 it does not update sheet2.

Any advice would be greatly appreciated! Thank you.