Dear All,
In excel 2003 I have an excel file with two sheets:
Sheet 1 contains an input sheet for my users - this sheet is called: "Resource pool", I have several data in the sheet. In column E I have dropdown menues for each cell - The user can determine diffent allocation types. In columns G to BC is the input fields.
Sheet 2 (called AllocationTypes) contains default input values for each allocation types. In Column A is stated the same allocation types as in sheet1 - and the default data is in column D to AZ.
What I would like to happen within VBA is, that based on a change in a dropdown menu in sheet 1, it will copy the default values from the AllocationTypes sheet in the input sheet..
Afterwards the user should be able to adjust the default values in sheet 1; - if they would like to do that.
Can you please advice me with suchs a macro
Thank in advance
Kind regards
Ransborg
In excel 2003 I have an excel file with two sheets:
Sheet 1 contains an input sheet for my users - this sheet is called: "Resource pool", I have several data in the sheet. In column E I have dropdown menues for each cell - The user can determine diffent allocation types. In columns G to BC is the input fields.
Sheet 2 (called AllocationTypes) contains default input values for each allocation types. In Column A is stated the same allocation types as in sheet1 - and the default data is in column D to AZ.
What I would like to happen within VBA is, that based on a change in a dropdown menu in sheet 1, it will copy the default values from the AllocationTypes sheet in the input sheet..
Afterwards the user should be able to adjust the default values in sheet 1; - if they would like to do that.
Can you please advice me with suchs a macro
Thank in advance
Kind regards
Ransborg
