IS it possible to automatically insert a new column immediately to right of a cell on condition of that cell having data inputted.

In essence, I want to expand my data table by 1 column each time data is input to the last column so there is always a 'fresh' column on the end waiting for new data.

Hope this makes sense.

Any help would be appreciated.

Rick