macro to run several functions

[luismonarez]

Good Day.

I am new to the whole macro thing and I hope someone can help me out with this macro question.

I am working on a time clock report and therefore would like your assistance.

I need to copy information from sheet 1.... Date, EE Number, Facility (code), pay type (1, 100, 103 etc,) and paste them on sheet 2. The catch is that if any row has data on pay type on (1, 100, 103 etc) then your have to past the following, Example

If the row has hours on Pay type 1, and 100

date... EE#...Facility (code),,Pay type..hours
1/1/13 123 aqwe 1 1.5

date... EE#...Facility (code),,Pay type..hours
1/1/13 123 aqwe 100 20


This information will then be moved to sheet 2..I apologize if I don't make sense but to make it easier I attached a copy and sample of what I want the macro to do,,,new time report1.xlsx

Thanks very much.