Copy & Paste a range after matching a input value with a column

Dear Friends,

I request a macro do do the following:

1) Take input in a dialog box
2) As per that input, check & match with values in a column
3) select & copy the data
4) paste it from next to last value in a column

I have attached a sample file in which I gave sample data and details of How & What to do.

I request experts for their support.

Is it what you need?

Please Login or Register  to view this content.

Sir,

Thanks for your code. Perfectly working.

But, just a request. I changed a column.

That is, need to copy & paste columns C to F only (in the previous sample, it was B to F).

I tried changing code. But, ended up with errors.

Please help me to resolve.

Here you are

Please Login or Register  to view this content.

Sir,

Thanks for your updated code.

But again the same issue.

As some formula is there in Columns A4:B5001, I dont want to disturb it while executing your Code.

Therefore, we need to copy & paste only columns C:F, only (without disturbing col A & B).

Please Sir.

See nexr revision.
If does not work please attach a new Excel sample with formulas

Please Login or Register  to view this content.

Sir,

As stated, I hereby attached the Sample file with your latest code.

Also, mentioned the formulas in Column A & B which are not to be disturbed.

Request your kind support.

You need to lock row in the formula
B4 =IFERROR(VLOOKUP(C4,Sheet2!$B$1:$C$21,2,FALSE),"")


Then try

Please Login or Register  to view this content.

As Bo_Ry mentioned it, keep in mind to freeze the range of the Vlookup
In the next code formulas are copied down

Please Login or Register  to view this content.

Thanks a lot to PCI & Bo_Ry.

I got the solution.

You're welcome and thanks for the rep.