Posts by s2nshend

    I am trying to get a control log going with one column holding information which determines whether it is sorted into any one of five other worksheets. I have no CLUE as to how this can be done! Example There are 5 different batch types. I have 5 different worksheet tabs. I want to give a statement that if the cell in the master column has a type '2' for example, the information will be copied to the first empty spot in the other worksheet.

    The worksheets are all the same format, except I want the others to 'specialize' in just the master set of information. Does this question make sense to anyone?

    PS I am a whiz at excel but have very little programming knowledge or logic function knowledge.