First time posting so I'm not sure what information is necessary but I will try to explain the best I can.

I have a macro to create named sheets based of unique data in column O

Now I am trying to get some help on copying all data in Columns A - AF on the original worksheet, even if blank, for all rows in which "X" exists in Column O and having them copied to the Sheet in which the data in Column O matches the Sheet Name.

Row A = Header

Small example:
So within Column O there are 4 names: Joe, Bill, Steve, Craig (these names repeat over the course of 200 lines)
From my 1st macro; I create 4 additional sheets with the above names

Now i need:
If column O in "originalsheet" = Bill, All data in that row will copy to the named sheet "Bill", even if the cell is blank.


Thanks for any help if possible.