Macro to copy row

[Luphai]

I am looking for a macro that will copy from (Leave availability worksheet) anyone with more(>) than 15 annual_Days Available( column D)
to the summary worksheet. Please advise if it is possible to have the number of days being searched as a input box i.e if I want to change the
15 days to lets say 12 depending on what is being searched for.

[jraj1106]

Hi.

Try this macro:

Leave days.xlsm

[Luphai]

Thanks for the reply Jraj

is it possible to copy just first name(A1), Last name(A2) , Full name (A3) and the queried Column (D)?

[Winon]

Hello Luphai,

Perhaps you would like to try the attached WorkBook with an InputBox, to select what you want?

Also see the "Please Consider" note at the bottom of this post.

[Luphai]

Hi Winon

The macro works perfect is it possible to trim the copied fields to just first name(A1), Last name(A2) , Full name (A3) and the queried Column (D)?

[jraj1106]

Replace the previous code with this new one:

Please Login or Register  to view this content.

If solved please click the star below. Thanks.

[Winon]

Don't you actually mean; "is it possible to trim the copied fields to just first name(A1), Last name(B1) , Full name (C1) and the queried Column (D)?

The Code should just do that.

[Winon]

O.K. Try this WorkBook

[Winon]

Hello Luphai,

I have applied a different approach, and I am certain the revised attached WorkBook solves your issue.

[Luphai]

Hi Winon can we make >= to Lsearch value as when I add the > operator it does not seem to work
check code attached.

Please Login or Register  to view this content.

[Winon]

No, that wont work.

I don't understand why you would want to do that, since the Value of the LSearchRow is derived from the exact Value entered in the InputBox, and cannot be less or greater than just that Value entered.

Try to enter any value not available in Column D of the Leave availability Sheet, and see what happens.

[Luphai]

Hi the reason is if anyone has more than lets say 9 days of leave available then HR
will advice or force them to take leave. Therefore the Lsearch value is the minimum days
you should have and the 9 days and above employees will be in violation.

[Winon]

9 days and above employees will be in violation

Will the attached work for you then?