Macro to copy name to one of two columns if a seperate cell value is true

[armynordy]

Hello everyone,

I am relatively inexperienced to VBA and am in desperate need of some assistance.

My task is to take a excel worksheet with a list of up to 500 emloyees with various data of each employee (birthdate, gender, department, ect) and create 2 lists dependant on a calculated value.

The range of my data is A2:AW500. What I need is for a macro to read each row, if column P indicates TRUE, then the emplyee name in column A is copied to the first empty cell in column AX starting at row 2. If column P indicates FALSE, then the employee in column A is copied to the first empty cell in AY starting at row 2.

I already have the formula in column P working. I just need help sorting the names.

Once the list is complete, I will name each column to reference them in other worksheets in my workbook.

Attached is a basic example of what I need.

Thanks in advance!

employee sort example.xlsm

[JieJenn]

Try

Please Login or Register  to view this content.

[JieJenn]

Actually use this one.

Please Login or Register  to view this content.

[armynordy]

Both worked perfect! Version 2 seemed to work a little faster.

Thanks for the help!