i want to try to use pivot tables, but i am really not familiar with it.

"muddan madhu" wrote:

use pivot table for better results



On Oct 22, 11:20 am, Eliz wrote:
how can i create a running balance when i have a real big data?

column a date
column b dept
column c doc no.
column d product code
column e product descriptiom
column f issue
column g received
column h balance

if i hv a really big database, how can i calculate the balance of each
product when i key in the received or issue figure?

Please help.

Thank you.

.