My First sheet is titled "D-4 listing" and contains all of the data for other sheets. I have columns F thru P that I put an "x" in if the information on the sheet corresponds with A thru E. I have set up separate worksheets for the F thru P columns.
What I would like is for the data that has been entered in my main worksheet ((02) M&I) to automatically populate the corresponding worksheet based on if the "x" is in the column F thru P.
Thanks for your help. Need anymore info then let me know :)