First post and I thank this form for existed and its assitance
I am relativly experienced with Excel and VBA but I am trying to think of a simple solution to this problem. I dont plan on using any macros at this point altho it is a possibility.
Im not really sure how to word what I am asking but I am trying to use a pull down list to determine the type of form that excel will display. for example cell A1 you will choose Type 1, Type 2, Type 3 etc. and then the rest of the sheet will adjust according to which value you chose. Is there a way to do this with out having the entire spreadsheet full of many IF("type1", value1) statements?
thank you in advance. Ill be checking back to clarify if anybody is willing to help.
Bookmarks