I have an Excel 2016 Workbook that contains a Worksheet (Tracker). Within the Tracker Worksheet, I have a table that spans from B12:Q. Column B is the Action# and Column M is the ActionResponse. When Columns B & M match then the content contained in columns N thru Q is a response to the Action# in Column B. So, when columns B & M match I need columns C thru L to automatically copy the original action information to the new row(s).
I’ve included the sample data set below for clarification. In the example below, Columns B & M values match in rows 1, 4, & 6 but the original action data is only contained in the first Column B entry.
In would like to have Rows 1, 4, & 6 all contain the same data for Columns C thru L while Columns N thru Q remain unique as shown in the example data set below.
Is there vba logic than I can use to accomplish this task?
Any and all help is greatly appreciated!
I’ve included the sample data set below for clarification. In the example below, Columns B & M values match in rows 1, 4, & 6 but the original action data is only contained in the first Column B entry.
| B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q |
| 1 | XY | YY | YZ | ZZ | ZA | AA | AB | BB | BC | CC | 1 | SS | TT | UU | VV |
| 2 | 2 | ||||||||||||||
| 3 | 3 | ||||||||||||||
| 1 | 1 | 11 | 22 | 33 | 44 | ||||||||||
| 4 | 4 | ||||||||||||||
| 1 | 1 | A7 | B8 | C9 | D1 |
In would like to have Rows 1, 4, & 6 all contain the same data for Columns C thru L while Columns N thru Q remain unique as shown in the example data set below.
Is there vba logic than I can use to accomplish this task?
| B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q |
| 1 | XY | YY | YZ | ZZ | ZA | AA | AB | BB | BC | CC | 1 | SS | TT | UU | VV |
| 2 | 2 | ||||||||||||||
| 3 | 3 | ||||||||||||||
| 1 | XY | YY | YZ | ZZ | ZA | AA | AB | BB | BC | CC | 1 | 11 | 22 | 33 | 44 |
| 4 | 4 | ||||||||||||||
| 1 | XY | YY | YZ | ZZ | ZA | AA | AB | BB | BC | CC | 1 | A7 | B8 | C9 | D1 |
Any and all help is greatly appreciated!
