I have an excel file with two worksheets and currently have a manual solution in place where I have to move contracts after the expiration (which are listed in rows) to the next worksheet. Is there a formula, etc. available to move the contract, or notify me, prior to the 30 days of expiration? It would be great if the row can be moved from Worksheet A to Worksheet B prior to the expiration. Any ideas would be greatly appreciated.
will you explain little more on this or pls attach sample file.