A
Amanda
Hi
I am trying to create a spreadsheet to record hourly transactions. There can
be 4 transactions in any hour. This is the layout
c13 Transaction ID
C14 Start Time
C15 Stop Time
C16 Qty Rec'd
C17 Qty Del'd
C19 Transaction1
C20 Qty Rec'd
C21 Qty Del'd
C22 Transaction2
C25 Transaction3
C28 Transaction4
C31 Total Rec'd
C32 Total Del'd
This layout is copied down for all 24 hrs in the day.
in Col A is the hour that the transaction occurs. A18 =1 A33=2 etc
When the user enters a transaction in C13:C17 i would like to click an ADD
button that will copy the information down to the corresponding hour. If the
user should try to enter more than 4 transactions I would like a pop up box
indicating that 4 transactions has been exceeded.
Thanks for all of your help!
Amanda
I am trying to create a spreadsheet to record hourly transactions. There can
be 4 transactions in any hour. This is the layout
c13 Transaction ID
C14 Start Time
C15 Stop Time
C16 Qty Rec'd
C17 Qty Del'd
C19 Transaction1
C20 Qty Rec'd
C21 Qty Del'd
C22 Transaction2
C25 Transaction3
C28 Transaction4
C31 Total Rec'd
C32 Total Del'd
This layout is copied down for all 24 hrs in the day.
in Col A is the hour that the transaction occurs. A18 =1 A33=2 etc
When the user enters a transaction in C13:C17 i would like to click an ADD
button that will copy the information down to the corresponding hour. If the
user should try to enter more than 4 transactions I would like a pop up box
indicating that 4 transactions has been exceeded.
Thanks for all of your help!
Amanda