I have a workbook with a "master client" sheet containing basic data in 5
colums(first name,last name, ID#, date and funding source) I then have 12
sheets (one for each month) where that information is copied using the
formula: =IF('MASTER LIST'!B3<"",'MASTER LIST'!B3,"") for each cell, with 5
columns to the right where numrical data is entered. PROBLEM: When new
clients are entered on the master sheet and alpha sorted, while the client
info on the other 12 sheets is alpha correct, the coresponding data entered
does not follow the client. How can I be sure data follows the new sort?