If you highlight the cell and go to format cells, doesn't the cell type show automatically? Then you can change it from that to what you want it to be recognized as.
Posts by s2nshend
-
-
Can any one of you smart people help with my control log ? Even the author of this question knows way more than I do.
-
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.