Here is what I would like to do:
-I have a Multi-Sheet Excel Project (Being used as an inventory/sales/expense tracker & all auto-populating into a P&L statement)
-What I want is a "main" sales data Entry sheet. This sheet will include 3 separate inputs:
1) The Item sold /Item No.
2) The Quantity sold
3) The Date the item(s) were sold
-On this entry sheet, I would like there to be a "Submit" button, that when clicked, will not only auto-populate the data- that was input to all other corresponding sheets - BUT also then, clear the data just input, and be ready for a new submission.
If this makes sense, and is possible, please let me know the steps to follow. And thank you in advance for any help!
****SEE ATTACHED SCREEN SHOT FOR REFERENCE****
