Test.jpg
What I require
• Identify the row the macro button is in, copy the 7 cells of data to the left of it in that row (data only ie not colour of cell etc) (from column B to column I)
• Paste row into next available row in separate worksheet
There are thousands of rows of data so I require a macro that all buttons are assigned to. I also need to know whether I will need Active X control or Form buttons.
The end product is that everytime a button is clicked that row is copied and pasted into the next available row in a separate worksheet.
What I have tried
By visual basic experience is limited to say the least. I normally record macros and edit them where required and this particular coding is well above my level of expertise.
I have searched the web and found that the following will be part of the coding for locating the row the button is in.*
*ActiveSheet.Shapes(Application.Caller).Name*
I have also found that the following will be part of the coding for pasting the information into the next available row.
*
*
Any suggestions for anything I could look into etc would be greatly appreciated.
Many thanks.
Bookmarks