I have been struggling with an excel problem for a few days now. My Excel workbook has two sheets titled 'Sheet1' and 'Sheet2'.
The headers in both workbooks are identical and range from A2:M2.
What I am looking to achieve through vba is to introduce a button at the end of each row N3, N4 etc. that will remove the row and paste it into the 'Sheet2' next available row. I would need max 100 buttons in Rows N3:N102. If macro button N10 (for example) is selected, it would copy the contents A10:M10 from 'Sheet1' into the next available row (after A2:M2) in 'Sheet2'. And also remove the line A:10:M10 from 'Sheet1'. while maintaining the 100 Buttons...
Does this make sense as to what I am trying to achieve? all coding I have searched to date does not include the button functionality.
Thanks for your help and time.