Copy Column A down to bottom of column B

[oneillp1]

I am trying to figure out how to have a macro check last row of column B and then copy the contents of A3:A11 down to the last row of column B. I have a code that i use to check the last row of column C and copy the contents of D3 down to the last row of column C, but it doesnt work from column A.
Code to check column C and copy D3 down

Please Login or Register  to view this content.

Modified code to check column B and copy A3:A11 down.( I know the range selection is incorrect)

Please Login or Register  to view this content.

Any help would be great. See attachment for example of what i am looking for, before and after

[AB33]

Try,

Please Login or Register  to view this content.

[PCI]

Perhaps

Please Login or Register  to view this content.

[oneillp1]

thanks for all the help.