How can I create a button that you can click to send data from a range of cells to the next available cells in a specific column on another sheet?
For example, the title of the button is Click to order and the click will transfer the text and numbers from Cell range D4-G4 from the sheet(Inventory) to the Order sheet's cell A2-D2.
I am new to this field and would really appreciate if someone can help me with the following:
1)How to Create a clickable Button.
2)Create a macro to perform the function.
3)How to post the macro.
Thanks in advance.
Bookmarks