Calculating a running count of ticket sales in VBA

[snowthedirtbub]

I'm trying to calculate a running total of ticket sales with 5 different groups (adult, youth, senior day, senior night, and child) to where once the number of tickets are bought it will update automatically. I enter the tickets in cells B5-B9 where it then calculates the amount due and the change due. I need to put the running total in cells B18-B22. I've been stuck on this for 3 hours now and any help would be appreciated.



Here is the code I have done that is calculating the cost and change due, I don't have anything for the running total because I don't know where to start.

[BrianM45]

Hi snowthedirtbub

Why do you use VBA for calculating !?

Can we have a example workbook ?

[snowthedirtbub]

Hello, thanks for the response

I'm using VBA because its for a class and that's the requirement. Pardon my ignorance but how would I upload an example workbook? Through the attachment link?

[BrianM45]

Clic [Go Advanced] in bottom of this page

Next [Manage Attachments]

[snowthedirtbub]

Thanks,
This attachment is the one without macros enabled, the other one I posted before is with macros.

[BrianM45]

Hi

Your workbook with correct code
SFCableCarPart2HelpNM.xlsm

[snowthedirtbub]

Thank you so much! If you were in person right now I would hug you! I've spent the best 5 hours trying to figure this out! I'm gonna go through what you did today/tomorrow, do you mind if I PM you any questions I have?

[BrianM45]

Thank you so much! If you were in person right now I would hug you!

Thanks

do you mind if I PM you any questions I have?

No you can, but i'm french and there jetlag ;-)