K
KENG
hi. my situation is like this. i have to monitor daily receipts of a
commodity delivered to the plants (12 diff plants). In a day, deliveries
varies from zero to 10 or more trucks. But the important thing is the
total of the items delivered in a day ( so i settle in using excel's
subtotals). But i need to do this to 12 sheets (1 sheet/plant), and
transfer manually the results to my "summary of daily delivery per plant
" sheet. i wish to link all my subtotal results to the summary sheet but
if i do the simple linking, it will be tediuos and time consuming. Can i
automate this using excel? I tried to use ms access but i am not well
versed of the system. Can somebody please help me? thanks.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **
commodity delivered to the plants (12 diff plants). In a day, deliveries
varies from zero to 10 or more trucks. But the important thing is the
total of the items delivered in a day ( so i settle in using excel's
subtotals). But i need to do this to 12 sheets (1 sheet/plant), and
transfer manually the results to my "summary of daily delivery per plant
" sheet. i wish to link all my subtotal results to the summary sheet but
if i do the simple linking, it will be tediuos and time consuming. Can i
automate this using excel? I tried to use ms access but i am not well
versed of the system. Can somebody please help me? thanks.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **