Generate a list from two lists

**ioncila** · 06-21-2012, 11:31 AM

Hi
I need some help with this please:
I have a file that generates, via userform, two lists of data (in the attached example: Cod and NAME cols).
What I want to do is to create another list based on those lists as shown in the example (ACTORS col).
So that avery new record created will generate another one in ACTORS' List. And this list must be a defined mnamed range.

I have searched in forums but got no luck.
Thanks in advance
Ioncila

**NBVC** · 06-21-2012, 11:37 AM

Do you mean with formula:

=TEXT(A2,"0000")&" "&B2

copied down.

Then create dynamic named range with Refers to formula:

=Folha1!$F$2:INDEX(Folha1!$F:$F,COUNTA(Folha1!$F:$F))

**ioncila** · 06-24-2012, 02:25 PM

Hi
Sorry for the late reply
Your help was very good. Although it didn't answer directly to my issue, it had lightened the way to the solution I want.
Thank you very much
Ioncila