separate different data from one column another columns

[standa]

Hi everybody,

I need to solve this problem:

I have 4 columns.
In first are names of employee.
In second are status of employee attendance: arrival, left, lunch, doctor, vacancies etc.
In 3rd column is date and in 4th column is time.

I need to separate each enmployee with his status, dates and time to one sheet (4 employes = 4 sheets). Then separate date and time of status from one column to another columns base on type (arrival, left, lunch...)

Thanks lot.

Stanley

[protonLeah]

Please post a small workbook with sample data, so we don't have to try to create our own random data to test formulas/macros.

[standa]

Hi

I attached file with example.

Stano

[protonLeah]

Please try the following macros (note that some of the dates and times on your sample sheet were not entered/formatted properly)

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name "Filter2Tab" to Run it.