Hi All,
I'm looking for a for a macro or formula that recognises a change in Column A, then at each change, it copies the same row from column B, pastes the value to column C and fills the next months downs until the next change in column A. At the moment I have Column A and B however I want it to create column C for me...??
<tbody>
</tbody>
thankyou in Advance.
I'm looking for a for a macro or formula that recognises a change in Column A, then at each change, it copies the same row from column B, pastes the value to column C and fills the next months downs until the next change in column A. At the moment I have Column A and B however I want it to create column C for me...??
A | B | C |
1112 | OCT | OCT |
1112 | OCT | NOV |
1112 | OCT | DEC |
1113 | FEB | FEB |
1113 | FEB | MAR |
1114 | AUG | AUG |
1115 | MAR | MAR |
1115 | MAR | APR |
1115 | MAR | MAY |
1115 | MAR | JUN |
1116 | SEP | SEP |
1116 | SEP | OCT |
1116 | SEP | NOV |
<tbody>
</tbody>
thankyou in Advance.