tinydancer
New Member
- Joined
- Jun 15, 2016
- Messages
- 44
I am trying to write a macros so that a given column will autofill a given range based on the last cell. Below is an example to better explain what I need:
Michael
Michael
Richard
Richard
Tyler
Sam
Sam
Billy
Billy
Chad
Chad
Pretend these given names are all in the same column (lets say column A) in excel and the spaces between them represent blank cells. I need those blank cells to autofill with the given names at the top and bottom cell. Some of the cells only take up one or two cells as shown and therefore will not need to be touched. I'm having difficulty because the blank cells range in length and I also need it to stop on the last name in the column where ever that may be (last cell is not specified). If anyone could help I would be appreciated, this is for an internship I have.
Michael
Michael
Richard
Richard
Tyler
Sam
Sam
Billy
Billy
Chad
Chad
Pretend these given names are all in the same column (lets say column A) in excel and the spaces between them represent blank cells. I need those blank cells to autofill with the given names at the top and bottom cell. Some of the cells only take up one or two cells as shown and therefore will not need to be touched. I'm having difficulty because the blank cells range in length and I also need it to stop on the last name in the column where ever that may be (last cell is not specified). If anyone could help I would be appreciated, this is for an internship I have.