In order to retain the original data in a worksheet, I have created a
second worksheet that pulls cells row by row, cell by cell to do data
manipulation and calcuate results. My problem is when a new row is
added to the original worksheet it does not update the second
worksheet with the new data. If I re-sort the original sheet the new
row does come over. To get the data to the second worksheet I'm
basically just referencing the original worksheet cells from the
second, eg, ='sheet1'!A1 across all columns and all row. Is there a
better way to bring the original data over that will allow for
automatically updating on the second worksheet? I must keep the
second worksheet protected, except for 4 columns for user input. Any
help is appreciated.