r/excel•
razorbackmac

Can I use excel to automatically produce a billing statement for multiple people?

solved

I am trying to simplify the procedure of producing monthly bills for employees that go over on their cellular data. Currently, I dump the data that I receive from Verizon into a spreadsheet. One of my worksheets has a Pivot Table that shows who went over their data limit and by how much. Then I open a word document and manually create a billing statement for each employee that went over that states how much data they used and how much they must pay for doing so.

Can I use excel to somehow create a billing statement for anyone that shows up in that Pivot Table? I am expecting this to be somewhat complicated but if I can get something set up and never have to touch it again, it will be worth the effort. Then again, maybe someone here knows a very simple way to do this and I am just being dense.

Posted Aug 14, 2017, 7:25 PM UTC

33
Loading comments…