Macro to copy selected column data and always paste into same Column

[rudogg]

Hello:

I am looking to create a macro that will be a ribbon button, that will copy values that have already been selected by the user, in either columns C,D or E and always paste them in column B. See table below for an example.

The user selects cells 1, 2 and 3 of data in col C and runs the macro assigned to the button and that will copy and paste the selection into cells 1, 2 and 3 of Col B.

The user selects cells 4, 5 and 6 of data in col D and runs the macro assigned to the button and that will copy and paste the selection into cells 4, 5 and 6 of Col B.

The user selects cells 7, 8 and 9 of data in col E and runs the macro assigned to the button and that will copy and paste the selection into cells 7, 8 and 9 of Col B.

I hope this all makes sense.

Col A current price	Col B new price	Col C 10% off current price	Col D 15% off current Price	Col E 20% off current price
10	9	9	8.5	8
100	90	90	85	80
1000	900	900	850	800
123	132	423234	132	654
345	5468	234234	5468	6521321
234	654	6546	654	654
476	1235	159	6575	1235
3645	32153	48654	315654	32153
467567	135158	6854	3586	135158

 

[ouvay]

Found the issue. the first array needs to start with 0
If col = arr(0) Then

Works like a charm now!

Thank you so much for your help.

Yup

Option Base 1

That's why I had this line in at the very top... You need either or

 

[ouvay]

I'm glad you figured it out! Happy pricing