Jun 13 2022 08:32 AM
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 within the workbook that gives me the following information:
copies information of a row when the conditional formatting of the expiration date is met into a new sheet.
copies information of a row when the stock levels fall below the reordering level set into a new sheet.
I've never created a VBA.
Jun 13 2022 10:54 AM
I have two recommendations for you:
A) Concentrate more on creating a functional basic data table and less on making it look beautiful (with colors and formats). Conditional formatting is fine, but good spreadsheet design textbooks all recommend against such things as big title rows that combine columns, and excessive use of colors for display purposes only.
B) Look into the FILTER function. Unless I'm mistaken, that will enable you to do both of the things you're seeking to do,
Here are two good references for FILTER
https://exceljet.net/excel-functions/excel-filter-function
https://www.youtube.com/watch?v=9I9DtFOVPIg
Jun 13 2022 12:26 PM
Jun 13 2022 01:04 PM - edited Jun 13 2022 04:56 PM
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.