Hello all, I'm in my mid fifties and completely new to computing and particularly excel. I am recently retired due to ill health and started a project to teach myself through online tutorials and Youtube videos.
Forgive my method of explaining what I require as I know no other way with the use of proper technical terms/language.
I have a worksheet where I would like to have excel automatically drag and fill into empty cell columns.
The cells in the range are H1:AP1501
So the range for each column that the code should only effect is H1:H1501, I1:I1501, J1:J1501, K1:K1501 and so on across as far as AP1:AP1501
The code should search in the range H1501:AP1501 for blank/empty cells in this range.
Any blank cell in this range should be filled, so if P1501 is blank and Q1501 is not, the range P11501 should be filled with whats in the range Q1:Q1501
When I say filled I mean that Q1:Q1501 contents should be dragged into P11501 not duplicated in so appearing twice on the worksheet.
I cannot just simply delete a column, as there is data in all columns past row 1501.
I would be extremely grateful if someone could provide me with the code that I can copy & paste in to do the above.
Thanking You In Advance.
Forgive my method of explaining what I require as I know no other way with the use of proper technical terms/language.
I have a worksheet where I would like to have excel automatically drag and fill into empty cell columns.
The cells in the range are H1:AP1501
So the range for each column that the code should only effect is H1:H1501, I1:I1501, J1:J1501, K1:K1501 and so on across as far as AP1:AP1501
The code should search in the range H1501:AP1501 for blank/empty cells in this range.
Any blank cell in this range should be filled, so if P1501 is blank and Q1501 is not, the range P11501 should be filled with whats in the range Q1:Q1501
When I say filled I mean that Q1:Q1501 contents should be dragged into P11501 not duplicated in so appearing twice on the worksheet.
I cannot just simply delete a column, as there is data in all columns past row 1501.
I would be extremely grateful if someone could provide me with the code that I can copy & paste in to do the above.
Thanking You In Advance.