How Can I Change Columns Based on User Input?

[bman100]

I have a worksheet that includes user input regarding the number of months required for the cash flow. I want the cash flow spreadsheet to automatically adjust (contract/expand) the number of columns pertaining to the number of months in the cash flow (the months are listed on the top of the speadsheet). I have some calculations on the right side of the spreadsheet that need to adjust as the cash flow columns adjust. I know I can use the hide feature to hide unused cash flow columns, but I would like something a bit more sophisticated. I cannot find out how to do this, and I have been trying!!!

 

[Ralph Gregory]

Ha well yes...I do plumbing and heating for a living so not in my sphere really...if I can help with the vba feel free to post...