J
Jeff King
Hi,
Please bear with me as this post may be long.
Any help with this problem is greatly appreciated. Using Excel97.
I have a workbook where each sheet is a monthly summary of $ values
for jobs done and who the job is for. (along with alot of other info).
What i am trying to do is:
1) Search through column E for each individual company name and
create a running total of billed amounts in another worksheet named
Summary.
2) Store the name of each company and the total of all money billed
to them in another worksheet named Summary.
3) Use the Summary sheet to keep track of company billing for month
after month.
format for Summary sheet is:
Company name Month 1 Month 2 Month 3 etc
Company 1 $xxxx $yyyy $zzzz
Company 2 $aaaa $bbbb $cccc
$xxxx - this is a total of all the amounts in October's sheet where
company 1 is found
etc.
Thanks for any help.
Jeff King
Please bear with me as this post may be long.
Any help with this problem is greatly appreciated. Using Excel97.
I have a workbook where each sheet is a monthly summary of $ values
for jobs done and who the job is for. (along with alot of other info).
What i am trying to do is:
1) Search through column E for each individual company name and
create a running total of billed amounts in another worksheet named
Summary.
2) Store the name of each company and the total of all money billed
to them in another worksheet named Summary.
3) Use the Summary sheet to keep track of company billing for month
after month.
format for Summary sheet is:
Company name Month 1 Month 2 Month 3 etc
Company 1 $xxxx $yyyy $zzzz
Company 2 $aaaa $bbbb $cccc
$xxxx - this is a total of all the amounts in October's sheet where
company 1 is found
etc.
Thanks for any help.
Jeff King