Vba - find next empty column, insert column, copy paste values & copy paste formulas

I am creating a report that will be updated monthly then create charts with the newly pulled data. I need to create code that will:
• Calculate current date, determine previous month's 1st and last dates
• find last column that contains data
• copy & paste values of that column (within that same column)
• find the next available blank column and insert a new column
• copy the master formula column
• paste formulas in the newly inserted column
• calculate
• Hide any columns older than 6 months.

Unable to open your file. My system gives me two error messages. One indicating that it is already open by someone else and that the file extension is invalid. I am operating EXCEL 2010 and I have no other instances of excel open. I believe that your file may be corrupted. Please try re-creating and uploading again.