I don't have anything close to working yet. My boss needs to know if an item has been in inventory for more than 120 days added to a weekly report. It sounds easy at first, I have to manually accomplish the task and hoping someone has an idea. I'm okay with VBA or Formula or anything that is close that I can work off of. Any thing would be appreciated!
1st. I use dated if formula to count #days between column (AF) & Today then,
2nd. Filter Column (F) with just "N" & Blanks. Column (F) Only contains ( Y, N, Blanks) then,
3rd. Filter Column AH only Blanks. Column (AH) only contains Dates when an item has shipped. then,
4th. I manually enter the total lines that are over 120 days in a cell on our report sheet & copy and paste the list to a summary sheet in the workbook.
1st. I use dated if formula to count #days between column (AF) & Today then,
2nd. Filter Column (F) with just "N" & Blanks. Column (F) Only contains ( Y, N, Blanks) then,
3rd. Filter Column AH only Blanks. Column (AH) only contains Dates when an item has shipped. then,
4th. I manually enter the total lines that are over 120 days in a cell on our report sheet & copy and paste the list to a summary sheet in the workbook.