Thanks Patrik! One more question. After the button is clicked, the data to be pasted (e.g. from Sheet1 to Sheet3) must be appended to the table in the Sheet3. (I need to append a row of data). How can I ensure that it is pasted just after the last row in Sheet3?
Hi,
Can anyone help me? I have a control button on a sheet to which I need to attach a macro. The problem is that I don't quite know how to create this particular macro. This is how the button should work.
When clicked, the data entered on that sheet(e.g. Sheet1), should be copied and pasted...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.