DanG
Registered User.
- Local time
- , 17:03
- Joined
- Nov 4, 2004
- Messages
- 477
In column "A" I have text "North Bay" then there will be empty cells for maybe six or seven rows down and then it will have "South Bay". Basically I would like to fill the empty cells with the cell value above until a new cell value is found so it will look like:
North Bay
North Bay
North Bay
North Bay
North Bay
South Bay
South Bay...
I don't know VBA so scap that approach.
I've tried variouse VLookup type functions with no luck.
Thank you
North Bay
North Bay
North Bay
North Bay
North Bay
South Bay
South Bay...
I don't know VBA so scap that approach.
I've tried variouse VLookup type functions with no luck.
Thank you