I have a couple of questions regarding managing the enormous amount of data I
see everyday that I simply cannot find a way to execute it in an excel Macro.

Basically my macros end on the block of my recorded macro how do make
encompass the whole column or sheet as the speadsheets I consoldate become
larger?

Secondly, I have to add a zero in front of every number (under 10) in a
specific column only. the only way i do this now is by changing the column
to text an maually copy paste.