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

WINDOWS 7
EXCEL 2010

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.
Attachment 94407

you want someone to do this for you? or you have a question?

I'm a novice at VBA and know most of the coding, but putting it together seems to not work. I'm getting stumped.

post what you have so far, with details as to what does not work, error, wrong result, nothing

alternatively post a sample workbook with the code, and details of what the correct results should be

as i only have an early version of excel i can only open .xls, so saveAs early version, then zip to post