VBA

I have a worksheet with multiple rows and columns

In each cell running down column A I have a macro button which when pressed should export just that line of data.

I have written the code to do what i want but when i try and apply the macro to the cells below it uses the same macro, and will export from the first row in the data base.

so basically i want the macro in A2 to cut and paste b2,c2,d2 etc. and the macro in A3 to cut and paste B3,c3,d3 etc.

How do i copy the macro down across say 100 lines and get it it to cut and paste just the info on that line, because at the moment i would have to write 100 macros.

Many Thanks for any help you are able to offer

Kind Regards

Ed