Hi Folks,
Looking for Some code to copy and paste but each time the data changes to fill in the blanks. So in column a and b have are the range.
I want the code to copy a and a and paste it to the where b starts... then copy b and b and copy that to c.... and so on (the values in them cells is different)
It needs to find that range and the last row can be used on "C:C" as this has the data to the last row with no gaps
Looking for Some code to copy and paste but each time the data changes to fill in the blanks. So in column a and b have are the range.
I want the code to copy a and a and paste it to the where b starts... then copy b and b and copy that to c.... and so on (the values in them cells is different)
It needs to find that range and the last row can be used on "C:C" as this has the data to the last row with no gaps
| a | a |
| b | b |
| c | c |
| d | d |
