I have been struggling with this problem.

I have a 4 sheet workbook going, sheet 1 contains four colums; Name,
Address, phone, and priority (A,B,C). Sheets 2, 3 and 4 have the same
four colums, but I would like excel to automatically popluate those
colums based on the results of the priority column from sheet 1. The
end result would be a workbook where I can enter all data into sheet 1,
sheet 2 would fill with priority A data, sheet 3 with priority B data
and so forth.

Thanks...


--
Whitman
------------------------------------------------------------------------
Whitman's Profile: http://www.excelforum.com/member.php...o&userid=36716
View this thread: http://www.excelforum.com/showthread...hreadid=564472