CODEWITHSUNDEEP
selectcopyrangecompare
BobbyBobbyZ
BobbyBobbyZ

Reputation: 11

Excel VBA code to compare data in each cell one at a time, from a single row of 6 columns, to an array of 6 columns by 8 rows one cell at a time

Compare data per ROW starting with ROW CELL A2 thru F2 one at a time with the data starting in CELL A5 thru CELL F5, that fall within +2,+1,0,-1,-2 of the data as a RANGE. When parameters are met, and a match is found, based on the parameters used, then copy the content of each CELL, one at a time, to the ROWS starting at ROW CELL A15 to F15, then compare the next ROW and so on, until each CELL comparison has been completed.

Column A Column B Column C Column D Column E Column F
A2 B2 C2 D2 E2 F2

| A5 | B5 | C5 | D5 | E5 | F5 | | A6 | B6 | C6 | D6 | E6 | F6 | | A7 | B7 | C7 | D7 | E7 | F7 | | A8 | B8 | C8 | D8 | E8 | F8 | | A9 | B9 | C9 | D9 | E9 | F9 | | A10 | B10 | C10 | D10 | E10 | F10 | | A11 | B11 | C11 | D11 | E11 | F11 | | A12 | B12 | C12 | D12 | E12 | F12 |

Example

Column A Column B Column C Column D Column E Column F
115 131 144 149 151 201

| 113 | 143 | 160 | 152 | 178 | 219 | | 111 | 131 | 149 | 123 | 231 | 202 | | 222 | 115 | 116 | 149 | 136 | 103 | | 301 | 450 | 370 | 309 | 202 | 201 | | 117 | 505 | 600 | 290 | 339 | 149 | | 124 | 130 | 203 | 315 | 439 | 238 | | 117 | 149 | 219 | 317 | 153 | 331 | | 110 | 210 | 218 | 700 | 203 | 144 |

After parameters are met then copy to ROWS starting with A15 thur F15, then start the next ROW, to fill in the data.

Column A Column B Column C Column D Column E Column F
113 131 143 149 153 202
117 131 144 149 152 201
117 131 144 149 151 201

did not try because not sure where to actually start the process.

Upvotes: 0

Views: 8

Answers (0)

Related Questions