Copy whole row if cell X contains a number

Hi,

I got a (for me) quite challenging problem.

I have two sheets. One sheet called 'Input' and one sheet called 'Accrual'. Please see attached workbook (only a section of the workbook to show how the sheets related to my problem looks).

The 'Input' sheet is quite big (about 6500 rows), so I think I need a macro.

What I want the macro to do:

I want all the rows which contain a number in the column "Accrual" (column U) to be copied into the 'Accrual' sheet. I also want the Employee No., Full Name & Position (only shown in the first row column A, B & C in 'Input' sheet for each empoyee to show on every row copied to the 'Accrual' sheet.

Each "Employee box" is the exactly same size/setup/layout/number of rows etc.

Maybe not the best explanation, but if you look into the attached workbook, I have marked what I want copied in the 'Input' sheet yellow, and similar how/what I want (it) to show up in the 'Accrual' sheet.

The macro need to run from row 2 until row 6500 in the 'Input' sheet.

I don't expect any to touch this problem, but if you have time and interest to help it would be highly appreciated! :-)

Thanks venkat1926! It works perfect :-)

Only one question: if I hide some columns in the "Input" sheet, the macro doesn't copy these columns to the "Actual" sheet. Do you know how I possible may adjust it to do so?