Forum Discussion
DATA PULLING
I am creating a workbook that manages paint inventory where I track dates and have a reordering level column. I am stuck trying to figure out how to generate a list that gets created in another sheet...
The color is not for display purposes only. This Excel will be used as inventory control and the color matches the label that will be placed on inventory received. Many will have access to the data collected in this spreadsheet. I am wanting to eliminate the purpose of using the filter function and just have the information pulled automatically into another spreadsheet.
I apologize: my critique was referring primarily to the heading on your sheet (as shown in your image), not to the other colors, which I acknowledge could be functional.
Further, thought, the FILTER function I referred to DOES pull information into another sheet. It's quite different from the Filter capability applied to a table using the little caret at the top of a column. I trust you've taken a look at the links I provided.