Hello,
I'm working on a project at work that creates a excel spreadsheet looking at different stocks for different days. I need the spreadsheet to contain information for only the most recent 30 days. I am wondering whether there is a way that when I add new columns for new days that older columns will self-delete. What I'm trying to say is, for example, say that I am entering information for August 1st and the stocks that I am monitoring for that day, I am wondering if there is a way to delete the items that I was looking at on July 1st automatically. I figure that this would occur upon the creation of new columns that older ones would be deleted automatically. I need to consolidate the information because I want to be able to quickly look at the information and can't take the time to go through hundreds of reports. Another solution that may be possible would be a time limit upon the columns. I am curious as to whether it would be possible to delete columns after a certain length of time is reached. I hope that one of these is possible. Thank you for your help.
I'm working on a project at work that creates a excel spreadsheet looking at different stocks for different days. I need the spreadsheet to contain information for only the most recent 30 days. I am wondering whether there is a way that when I add new columns for new days that older columns will self-delete. What I'm trying to say is, for example, say that I am entering information for August 1st and the stocks that I am monitoring for that day, I am wondering if there is a way to delete the items that I was looking at on July 1st automatically. I figure that this would occur upon the creation of new columns that older ones would be deleted automatically. I need to consolidate the information because I want to be able to quickly look at the information and can't take the time to go through hundreds of reports. Another solution that may be possible would be a time limit upon the columns. I am curious as to whether it would be possible to delete columns after a certain length of time is reached. I hope that one of these is possible. Thank you for your help.
