Hi guys and girls,
I'm working on a new excel form and have the input ready, now the layout needs some more attention and i'm confused. I tried to understand the posts on the forum and found some interesting info, but not quite exactly the information i need.
I've got information in 8 coloms, A to H:
General Cost category Sub category applicable etc.etc.etc. Total cost
a, b a, b, c a, b, c, d, e, f yes/no 2 3 1 € 10,00
The input in row two is dependant from drop down menu's. If for instance you select general a, cost category b and sub cost category d is applicable "yes", then some other drop down menu's should exclude certain drop down options that cannot be used anymore as a result of this choise.
On the contrary: also after a specific selection of choises in the colums, it might mean that this cost category always comes together with another line with specific criteria, IE.: when in row 10 you make the choice for adding cost in category demolishing costs, excel should immediately insert a new line based on this criteria that selects the adherent cost, for instance the cost of cleaning up after demolishing which is this case is obligatory because it comes together with demolishing costs.
In this form I think I'd prefer working with drop down menu's but I'm nog quite sure if they work for the kind of result I want to get.
If you have better solutions, i would appreciate if you share them with me.
On this forum I already found information about inserting a line after certain criteria, but I guess this code needs adjustments as well.
Code:
Sub insertLine() Application.ScreenUpdating = False Set rng = Columns(1) 'change to whatever column number the criteria is in Set c = rng.Find(what:=2009) If Not c Is Nothing Then a = c.Address Do c.Offset(1, 0).EntireRow.Insert Set c = rng.FindNext(c) Loop While c.Address <> a End IfEnd Sub
Curious what you come up with!
Thanks already.
Twan
Bookmarks