ryan_law2000
Well-known Member
- Joined
- Oct 2, 2007
- Messages
- 738
Here is what I want to do
When you click on "REMOVE" found in cell A4 I would like a MSG Box to appear saying
"Please Enter Shipping Out Information"
"New Ticket #" then a box to fill in
"Location" then a box to fill in
"DATE" then box to fill in
then at the bottom, a "Cancel" and "Transfer Item"
When this info is filled out and the transfer button is pressed I would like it to cut the full row then transfer that line to a different sheet, pasting that line on the next available line on that sheet and also adding "NEW TICK #", "Location" and "Date" to the new sheet... These New Colums will already have the titles and the colums to paste the info.
Any ideas out there on how to do this? It sounds like i will need to create a userform but as for the transfering and cuting the line im really lost
When you click on "REMOVE" found in cell A4 I would like a MSG Box to appear saying
"Please Enter Shipping Out Information"
"New Ticket #" then a box to fill in
"Location" then a box to fill in
"DATE" then box to fill in
then at the bottom, a "Cancel" and "Transfer Item"
When this info is filled out and the transfer button is pressed I would like it to cut the full row then transfer that line to a different sheet, pasting that line on the next available line on that sheet and also adding "NEW TICK #", "Location" and "Date" to the new sheet... These New Colums will already have the titles and the colums to paste the info.
Any ideas out there on how to do this? It sounds like i will need to create a userform but as for the transfering and cuting the line im really lost