Hey everyone,
I am trying to do what I thought was a simple macro, however, not much luck currently, will post my current (although not functioned) code at the end of the day when I get to my home computer.
Heres what I want to do:
I want to copy the active cell to the cell below it, only if the cell is empty. Then go to the newly copied cell and repeat the loop. If the cell below activecell is not empty, I want to go to that cell and start the process again.
For example:
CARS COST
BMW $1,000.00
(BLANK) $1,000.00
MERC $2,500.00
(BLANK) $2,500.00
(BLANK) $2,500.00
HONDA $1,500.00
(BLANK) $1,500.00
(BLANK) $1,500.00
TOYOTA $200.00
FORD $150.00
(BLANK) $150.00
(BLANK) $150.00
I would want to look like:
CARS COST
BMW $1,000.00
BMW $1,000.00
MERC $2,500.00
MERC $2,500.00
MERC $2,500.00
HONDA $1,500.00
HONDA $1,500.00
HONDA $1,500.00
TOYOTA $200.00
FORD $150.00
FORD $150.00
FORD $150.00
I can run a very easy macro to just copy and paste cells down, but when there is no blank between two different labels (i.e. between Toyota and Ford) I get stuck.
HELPPP MEEEE.
Anyway, figured I'd see if anyway had an easy solution because it seemed very easy in my head.
Bookmarks