Transfer info to another sheet
Posted on 2014-07-28
I have a ss where i want rows A23:G23 to be transferred to tab "transfer"
I need the data to append, so first append into A2, then any further appends, a3, a4
So the user will press the button "Add", the code transfers "A23:G23" to "A2:G2" in sheet "transfer"
If they press add again, it transfers to A3:G3
If the user hits add twice, but the none of the data in A23:G23 changes, then the user gets a msg box "This is the same data, are you sure you want to send", if Yes, Send, if no, exit sub