ok, i'm very new to excel, infact i was scared of it up until a month ago when i began my 'very basic' applications course.
my query is this, i have a created a POS style worksheet, i have buttons that open other buttons and msg boxes, i even have a delete button that works! but i cant seem to be able to get my data to copy into worksheet 2 when i've finished putting the data in.
i would like my info from ws1 to copy into ws2 simultaneously, i would also like ws1 to basically blank at the end of the day and open empty the next day but all the info on ws2 to stay where it is. when i begin again the next day, i would like the info from ws1 to dump into the next available cell from the day before. am i making sense?
i would also like for my delete button to delete on ws1 but highlight and 'not' delete on ws2.
again, i stress that i am a complete blank slate when it comes to excel vba but i am keen to get to know it better. is it possible to be able to do what i want simply and with little code? or have i bitten of more then i can chew?
cheers for your time