Insertion/deletion of columns, via VBA, depending on variables

**wmfinance** · 08-27-2010, 11:31 AM

I have two worksheets in a cost estimate workbook that represent unit acquisitions. The first sheet is a continuous in/out life cycle over 20yrs. The second is a worksheet that displays a single unit life cycle, without any further purchases.

My dilemma is that I have only 10 fiscal year columns allotted to my second worksheet. To properly display this page, I regularly must add or subtract columns to show one full acquisition life cycle.

I have attached a dummy workbook to better express what I need/have, in a very simplistic manner. If you have any further questions please do not hesitate to ask.

Thank you for your help in advance, and as always I will bump reputations to those of you that can help me out!

Regards

**Palmetto** · 08-27-2010, 12:50 PM

There is no sample workbook attached and you mention nothing about the variables to be used to determine which columns get inserted or deleted.

Post the workbook and provide a clearer explanation and sufficient details to understand what you want to achieve and a solution will be provided.

**wmfinance** · 08-27-2010, 02:44 PM

Sorry for not posting.

If you see the worksheet, you will have a better understanding of what is needed. The variables are B3 & B4 (Year and Life Cycle) respectively.

Thanks