Forum Discussion

lucastyler_2277's avatar
lucastyler_2277
Copper Contributor
Nov 20, 2018

Help with "Data Entry Sheet"

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****

No RepliesBe the first to reply

Resources