May I ask for advice on how to auto update sheet2?
That is I have my data in sheet1. My answer in sheet2.
In sheet2 cell A1 I have the count value of sheet1 range A1:A1875.
So when I add new row of data in sheet1 the new range will be
A1:A1876.
How can I make Cell A1 in sheet2 auto update the count to A1:A1876
instead of manually changing the range everytime I make an update of
rows in sheet A1.

Thank you for your advice and sorry for the troubles caused.

With Regards
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/