VBA Macro to fill copied data uptill the last used row

Hello,

I want to copy B2 & B3 and paste it down till the last used row. Below is the pic

allocation.PNG


I tried it but i am getting an run time error 1004: The info cannot be pasted because the copy area and the paste area are not same size and shape.

Below is the VBA code:

Please Login or Register  to view this content.

Can any one help me on this

Thank You !

Regards
Wither

Try this:

Please Login or Register  to view this content.

Or this:

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

@Wither125
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Hello Subverter,

thanks for your reply the code works, but its pasting the names even to the un-selected data.

In the below code first i am filtering the country column and selecting US ,CA and then i want to assign Brandon ,Alan to US CA only. Below in the pic u can see there are three county US CA BR.

all.PNG

So the problem is its copying Brandon and Alan even to the BR though i am filtering US and CA.

Please Login or Register  to view this content.

Regards
Wither

Well Wither, how could we have known about the filter? Can you post a more relevant sample?

This depends upon the leading rows being filled:

Please Login or Register  to view this content.

Hello xladept,

i ran your code and its assigning Brandon to US and Alan to CA. But i want both of them to be assigned to US and CA as seen in the below pic.

alres.PNG

In the below code first i am filtering the country column and selecting US ,CA and then assigning Brandon and Alan to US,CA.

Please Login or Register  to view this content.

I tried your code but its its filling the names even to the un-selected data.

Please Login or Register  to view this content.

i want to copy B2 & B3 and paste it down till the last used row. So how do i do that?

Regards
Wither

How do you determine who goes where?

Thanks for the rep!