I'm not fully understanding how to set up the pivot table. I made a customer form for my wife's at-home bakery. The spreadsheet has items for sale, name , address, etc. I need a pivot table to tell me how many of item 1 or item 2 have been sold and how much money she made from each item. I would also like to create an order form to text to people so they can place their order. Right now they are texting my wife and it's taking too long to write it all in the spreadsheet. Is there a way that the information can be transfered from the order form to my spreadsheet without having to re-write everything?
Thanks for your help.
Thanks for your help.