Hi,
I would really appreciate help with the following that I have to do for work.
I have different account numbers scattered over different tabs in the same excel workbook where each account number has a USD amount. i.e different USD amounts for account A might be given in tabs 1,2 and 3.
I would like to program/use pivot tables etc so that when I write in a particular account number, a seperate sheet produces all the entries for just that account, and using the subtotal function in this new sheet, all the USD amounts are summed. (There are many other variables to be summed, but I have omitted them in this example).
Thank you
I would really appreciate help with the following that I have to do for work.
I have different account numbers scattered over different tabs in the same excel workbook where each account number has a USD amount. i.e different USD amounts for account A might be given in tabs 1,2 and 3.
I would like to program/use pivot tables etc so that when I write in a particular account number, a seperate sheet produces all the entries for just that account, and using the subtotal function in this new sheet, all the USD amounts are summed. (There are many other variables to be summed, but I have omitted them in this example).
Thank you