Can a macro convert text to numbers and also fill in missing lines

[gareth7412]

I have a workbook that downloads data with some as text and also gaps in the data.

What I'm trying to do is to be able to convert all the data from text to numbers all the way down columns B,D,H and then autofill the gaps in data by copying and pasting down.

What I mean is I want all the data copying down from A2-A29 and then A31-A44 etc. I then need it doing the same down columns B-F.
The only issue is it will always be the same column letters but not the same row numbers as data will be added to workbook daily.


Can this be done poss via macro?

[Norie]

You could do this easily with PowerQuery.

All you would need to do is select all the columns that you want to fill, goto the Transform tab and then Fill>Down.