Help With A Macro To Insert Data Into A Column

[gaspower]

Hello,

I need some help to finish up a macro. The current macro I am using is,

Please Login or Register  to view this content.

which gets me to this point of Image1 (attached as a file).

I need to fill column "C" with EOREOR down to match last data in column "A", as Image2 (attached as a file).

Sorry, tried to use HTML Jeannie, but does seem to work with Office 2010.

Thanks JR

[arlu1201]

This is simple. You need a loop to ensure that the data gets filled up.

Assuming that column A will have no blanks in between, your code should look like this:

Please Login or Register  to view this content.

[gaspower]

Hello,

thank you for the effort. I was able to get wit working with the below.

Please Login or Register  to view this content.

Thanks JR

[arlu1201]

Yes, your code should work fine as well.