| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotal automatically update
Hi to all
I am useing subtotal from data menu for my passbook. What i do is when i want subtotal i copy data into new worksheet and use subtoal from data menu. every time. Is there any way that i can be updated automatically when i type data in datasheet and it update in copy sheet where i used subtotal. Is any help. thanks Tiya |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
subtotal automatically update
Hi Tiya,
In a cell of your choice, type =SUBTOTAL(9,A1:A2000) adjust formula to reflect the column and number of line you want to add .... HTH Cheers Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
subtotal automatically update
You could have both sheets selected at the same time.
What happens then is that whatever is typed on one sheet appears on the other. Good luck "Tiya" wrote: Hi to all I am useing subtotal from data menu for my passbook. What i do is when i want subtotal i copy data into new worksheet and use subtoal from data menu. every time. Is there any way that i can be updated automatically when i type data in datasheet and it update in copy sheet where i used subtotal. Is any help. thanks Tiya |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update one worksheet tab to automatically update all other tabs? | Excel Worksheet Functions | |||
| How can I automatically print subtotal on last row of every page? | Excel Discussion (Misc queries) | |||
| automatically update hours | Excel Worksheet Functions | |||
| Need pivot table to automatically highlight subtotal rows | Excel Programming | |||
| Dates that automatically update ... | Excel Discussion (Misc queries) | |||
Hybrid Mode
