Hi All,

This is kind of complicated so I'll try to describe in steps:

1. Open worksheet (library)
2. Identify what group (this is like Test A) so this cell would be "A", "B" etc.
3. This would identify what Test sheet to send this information to. (when entry is B - send data to worksheet Test B when macro button selected).
4. Then Check column F for "X"
5. For each row that there is "X" copy columns B,D to worksheet "Test B" at the bottom of empty rows, in specified columns A,B. (don't delete original).

I went through the threads but couldn't find quite like this...

Help???