Hello Experts,
I am trying to record a macro to perform the following tasks when the smiley face is clicked
· Take the data from in cells C6 C8 C10 C12 & C14 in the Delivery Ticket sheet and enter them in the Index sheet
· Create a copy Delivery Ticket and rename it as per the Delivery Ticket number
· Clear the data from Delivery Ticket
· Give the now blank sheet the next consecutive number
I have attached the sheet here, any help would be greatly appricated
Kevin
Bookmarks