Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plse Advice
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plse Advice
What do you currently have in code or as a worksheet formula.
Is there anything in Column A that is not to be included? What kind of count, if you included the answer to the first question this would have been obvious. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Michael168" wrote in message ... 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plse Advice
On Sheet1 the column A range consists of different names.
On sheet2 the cell A1 was use to count / total no times the same names appear in column A Thank you. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plse Advice
Take a look in HELP index for COUNTIF
"Michael168" wrote in message ... On Sheet1 the column A range consists of different names. On sheet2 the cell A1 was use to count / total no times the same names appear in column A Thank you. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plse Advice
Michael168 wrote:
*On Sheet1 the column A range consists of different names. On sheet2 the cell A1 was use to count / total no times the same names appear in column A =COUNTIF(Sheet1!A5:A1815,"=Dave") Thank you. * ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plse Help - Can I recover my Password? | Excel Discussion (Misc queries) | |||
any advice pls.. | Excel Discussion (Misc queries) | |||
pls advice | Excel Worksheet Functions | |||
Spreadsheet won't let me merge cells. plse help. | Excel Discussion (Misc queries) | |||
Need help with generating a formula PLSE. | Excel Discussion (Misc queries) |