I've searched for nearly four days for a starting point to help with this project I have. Many simliar macros have been shared but I am just learning about marcros, so trying to figure out how to write it correctly is beyond me.
Project:
Take a list of inventory with inspection dates and create a work sheet that will list what part is due this month and next month. Also what is over due, and still have the capability to add new inventory to overdue section.
Issues:
The inventory is copy & paste as an array from a master sheet, and the rows cannot be altered.
The "C/W Date" is manual, but the "Due Date" is a formula taking the C/W date +182. (=cell+182)
Product is opened weekly, would like macro to update as of today() or current month
I could not find the icon to attach an example.
Project:
Take a list of inventory with inspection dates and create a work sheet that will list what part is due this month and next month. Also what is over due, and still have the capability to add new inventory to overdue section.
Issues:
The inventory is copy & paste as an array from a master sheet, and the rows cannot be altered.
The "C/W Date" is manual, but the "Due Date" is a formula taking the C/W date +182. (=cell+182)
Product is opened weekly, would like macro to update as of today() or current month
I could not find the icon to attach an example.
