Compare one group of 2 cells against several other groups of 2 cells, by copying/pasting the "other groups" to a formula sequentially down the rows.

Bobaree6

New Member
Joined
Dec 23, 2020
Messages
18
Office Version
  1. 365
Platform
  1. Windows
This Macro or VBA procedure would:
1. Copy Row Q9:CA9 down to equal the number of rows in Column A that contains data.
2. Go to selection B9:C9 and copy to Z9:AA9. (After this, no more changes to B9:C9)
3. Go to selection D9:E9 and copy to AB9:AC9.
4. Move down to selection D10:E10 and copy to AB10:AC10
5. Continue copying the two cells in D and E columns to the AB and AC columns to the last row containing data in D and E Columns.
6. End
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,130,427
Messages
5,642,058
Members
417,252
Latest member
selbysam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top