Good afternoon,
I need help copying from an offset column and then filling down. I know how many columns I have but the number of rows will vary so I can't set up a specific range.
My column names are A, B & C. As long as there is data in Column A, I need to copy the contents of cell B2 and paste it into cells C2, C3 and C4. But when the text in Column B changes, or when the first 8 digits in Column A change, I need the information in the adjacent B cell to be copied and pasted instead until the next change.
Here is what I have:
A B C
NL.00561 Capital
NL.00561.001
NL.00561.002
NL.00562 Operations
NL.00562.001
NL.00562.002
NL.00563.001 Maintenance
NL.00563.002
Here is what I want it to look like:
A B C
NL.00561 Capital Capital
NL.00561.001 Capital
NL.00561.002 Capital
NL.00562 Operations Operations
NL.00562.001 Operations
NL.00562.002 Operations
NL.00563.001 Maintenance Maintenance
NL.00563.002 Maintenance
Bookmarks