Need help with VBA macros -- 2
Budget: $10 – $30 AUD
I have a sheet with 10 columns (Id,name,Enteredtime,Lunchtimestart,Lunchtimeend,Exittime,Task etc). I would like to have a macro which creates another sheet with the following
1) 5 columns out of 10
2) Couple more columns are derived based on the data from 5 columns above
3) add a new row per everytime marketed in EnteredTime,Lunchtimestart,Lunchtimeend,exittime ( Eg a row in the input file has
123,TestCustomer,9:10 AM,12:20PM,01:00 PM,06:00 PM should be output as
123,TestCustomer,9:10,In,----
123,TestCustomer,12:20,Out,---
123,TestCustomer,01:00,In--
123,TestCustomer,06:00,out
1) 5 columns out of 10
2) Couple more columns are derived based on the data from 5 columns above
3) add a new row per everytime marketed in EnteredTime,Lunchtimestart,Lunchtimeend,exittime ( Eg a row in the input file has
123,TestCustomer,9:10 AM,12:20PM,01:00 PM,06:00 PM should be output as
123,TestCustomer,9:10,In,----
123,TestCustomer,12:20,Out,---
123,TestCustomer,01:00,In--
123,TestCustomer,06:00,out