VBA to copy and paste row below using selection from valdiation list

[hifliers]

Hi,

PFA sample file.

In sheet1 I have transection list. While entering data if i select Transection type as "[Transfer]", I need vba to copy same row and paste it below.

Regards,

Vishnu

[Miroslav R.]

Hi there,
since You want only to copy the 'Transfer' row, You can manage that with worksheet_change event:

Please Login or Register  to view this content.

I think, that You want to do some changes, but You do not mention that in Your post.

[hifliers]

Thanks!! M.R.

But here if i enter any value it copies row below, What i want is if i select [Transfer] then only copy and paste row.

As you said is right i want to do some changes in value after paste, I will try it self if not possible will create thread.

Thanks again!!

[Miroslav R.]

Hi there,
sorry for that wrong post...
Fixed:

Please Login or Register  to view this content.