Help me please

[aworth]

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.

 

[Datsmart]

Please continue in your original thread.
http://www.mrexcel.com/forum/showthread.php?p=2800131#post2800131

Take a moment to read over the forum's guidelines:
http://www.mrexcel.com/forum/showthread.php?t=127080
Specifically rule #21.
You want to keep all information in one location and simplify both your understanding and those that are trying to help you.

Maybe if you posted some sample data as an example someone can give you a solution. Hard to visualize what you need help with.

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).