Macro to find, copy, and paste until value change
On an imported worksheet I have a column that is mostly blanks with a company
number when the report changes. I would like a macro to go to the first
filled in cell, copy it and paste it into every subsequent blank cell until
the next company then copy and paste, etc to the bottom row. Ex:
Row-Value
1
2
3 - A
4
5
6 - B
Copy "A", paste to rows 4 and 5, copy "B", paste to following blank cells,
etc.
Thanks!
|