Fairfield
asked on
Excel VBA for filling adjacent cells
I need some code to fill adjacent cells with values from a preceding cells. However, if the cell contains a value alread, I need it to skip the cell.
I woud like the values form the adjacent (column) cells updated by the one from the preceding cell. However, if there is a value in the cells to be updated, I want to use it as the new value and fill in the remaining adjacent cells.
excel.JPG
I woud like the values form the adjacent (column) cells updated by the one from the preceding cell. However, if there is a value in the cells to be updated, I want to use it as the new value and fill in the remaining adjacent cells.
excel.JPG
ASKER
I would like this to be automated with VBA as there are over 38k rows of data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you just need to make a few infills, then...
Highlight the value you want to copy and the empty cells to the right of it that you want to fill, and press Ctrl+R. The empty cells will have the same value as the first cell you selected.