Excel Lookup?? Problem!

[LROCCO]

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

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

 

[dok112]

Hey Lui,

With an in-line verification as you want, it will be impossible to do
what you want. BUT, if you set up a pop-up (userform) box when you
click the add button you already have, you can have a combobox linked
back to the source data on the one sheet. Then with a Select Case
statement, you can tell the system how many times you want it to create
each line for each "case". Or. You can use a general reference select
case statement and have it refer back to the number of lines for each
type on the sheet containing the source data. This way if you have a
lot of data, your not writing a bunch of source code. I think I know
what you want to do. If this sounds about right, let me know and I
will look into helping you write the code.