Insert new columns into data range!

I hope someone can help me...This would save me tons of time if this function is possible.

In my workbook, I need to insert 2 new columns in order to input new data. However, when I insert the new columns, my data range does NOT include the new columns, thus I have to manually edit the formaulas in each worksheet.

The goal is to insert the new columns into the data range that also maintains the formulas from the adjacent columns.

I probably have not done a very good job of explaining this but hopefully someone out here can make sense of it or take some time to help out. I sure would apprciate it!

Thanks!

dbolan

One technique to consider:

If you are adding the columns at the end of your spreadsheet, and they are not included in calculations, try insering a column before the last column. (For example, if you last column is M, add a column BEFORE M). Usually, excel will automatically expand the calculation to include the last column, and it will also apply to new columns. Then, you can copy and paste special the data from that last column into whichever column you want it to be.

Let me know if that works.