Link to home
Create AccountLog in
Avatar of Fairfield
FairfieldFlag for United States of America

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
Avatar of chrisezard
chrisezard
Flag of United Kingdom of Great Britain and Northern Ireland image

Do you need this to be automated by VBA?
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.
Avatar of Fairfield

ASKER

I would like this to be automated with VBA as there are over 38k rows of data.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account