lui_roc
02-17-2006, 03:06 PM
I have officially arrived at a dead end. I know what I want to do, but for one, I don?t know if it?s possible, and for two, even if it is have no idea how to do! I would much appreciate some help on the matter.
To make it easy for me to explain I have uploaded the workbook to savefile.com
http://www.savefile.com/files/3037321 (http://www.savefile.com/files/3037321)
Referring to the worksheet called ProjectRegister - cell A8, I would like to select a risk source from a validation list. The validation list would use column B in the RiskSource as it source. Once a risk source had been select it would insert a number of rows depending on how many risk were associated to that source. For example, if railway (which has three associated risks) was select as the risk source, then two new rows would be inserted and the existing row in row 8 would act as the third. The rows that were inserted would copy the same formulas and validation as row 8 (I have created some similar code for this on the Add Row command button).
The following risk information will be automatically entered in the ProjectRegister from the RiskSource:
Risk Title (ProjectRegister column D) to Risk Title (RiskSource column C)
Risk Description (ProjectRegister column E) to Risk Description (RiskSource column D)
Action Description (ProjectRegister column N) to Action Description (RiskSource column F)
Other Possible useful information:
There will be hundreds of Risk Source Records
The user can enter a unique risk, which has no source ID. In this scenario the user will select custom in Risk Source filed and enter risk manually.
I would much appreciate any help on this problem.
Lui
To make it easy for me to explain I have uploaded the workbook to savefile.com
http://www.savefile.com/files/3037321 (http://www.savefile.com/files/3037321)
Referring to the worksheet called ProjectRegister - cell A8, I would like to select a risk source from a validation list. The validation list would use column B in the RiskSource as it source. Once a risk source had been select it would insert a number of rows depending on how many risk were associated to that source. For example, if railway (which has three associated risks) was select as the risk source, then two new rows would be inserted and the existing row in row 8 would act as the third. The rows that were inserted would copy the same formulas and validation as row 8 (I have created some similar code for this on the Add Row command button).
The following risk information will be automatically entered in the ProjectRegister from the RiskSource:
Risk Title (ProjectRegister column D) to Risk Title (RiskSource column C)
Risk Description (ProjectRegister column E) to Risk Description (RiskSource column D)
Action Description (ProjectRegister column N) to Action Description (RiskSource column F)
Other Possible useful information:
There will be hundreds of Risk Source Records
The user can enter a unique risk, which has no source ID. In this scenario the user will select custom in Risk Source filed and enter risk manually.
I would much appreciate any help on this problem.
Lui