Insert column before last column in table

Hi

I have a few sheets, with tables, which vlookup values from a data sheet which is updated every month.

Say I have 2 months, May and April, now I want to make June.

I insert a column between May and April and copy the values of *May* into this new column.

I then paste the new data sheet, then my last column is automatically updated for June.

I want to automatically do this job, but the macro recording records the column names...

Here is a recording of what I am doing:

Please Login or Register  to view this content.

Thanks!

Hi
Welcome to the forum.

For your information, any code that you include in your post, must be included within tags
"

Please Login or Register  to view this content.

"

(without the quotation marks.)

Now, as to your problem, it is difficult for me to follow what you are after, as I cannot see why you would want to place June, between April and May.
Can you attcah a copy of your workbook with a little more explanation?

what if using:

Please Login or Register  to view this content.

Hi,
Sorry for the confusion, here is a copy of my workbook...

I copy the values of the old month (May) into the new column and vlookup formula will get new months values (June).

Thank you!