Can I use excel to automatically produce a billing statement for multiple people?
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