sorting worksheets containing both imported data and user entered

L

leejb

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DATA FOLLOWING SORTS 0
Inputting data into more than one sheet at a time 7
Macro to Compile Data from Different Sheets 2
macro to copy formats 1
Alpha sorting (with a twist...?) 3
Autosort in Excel 2
formula crossing multiple worksheets 0
Need help linking spreadsheets and displaying only populated rows 1

Top