Count Populated Cells w/ VBA and Use Result to Fill other columns

[Ivanur55]

Hello All,

I want to be able to count all populated cells in column A, excluding headers. I then want to take the result of the count to fill other columns with a static information like vendor name or terms so that all columns have information to the same row. If I had to do this manually I would use the fill handle on all my static rows and then delete the excess (everything at the first blank in column A)

Thanks,
Ivan

[VBA FTW]

You can just use the COUNTA formula for the counting populated cells. However, to turn into a macro, can you provide a little more information? An example spreadsheet would be helpful. Need more specifics