Hi again.

"Do you want a macro to write the formula to all the rows in 800 workbooks?"

No.
A single row, and only one file at a time-- as I, or another tech. does a
file update.
I can take the equation, and drag it down once the other data is entered.

"Are all the workbooks laid out the same?"

For the worksheet in question-- Yes.
This particular worksheet was designed by me, and is being placed in old
workbooks as we do updates to them. Thus, the data would be confined to this
worksheet of each workbook.

What would this do for me...
It'd help me a lot, as it would 3 others with whom I work.
The goal is to have a list of the names, extract them from the drop down,
and upon being placed in the primary cell, be able to copy that specific
name, in that specific equation, down through a range that varies from 10-600
rows, depending on the file.
Presently, I'm having to manually extract the name from another worksheet,
and paste it into the "DecreedOwner'sName" portion of the equation.
E.g.
=if(A4="DecreedOwner'sName","B","C")
becomes
=if(A4="John Smith","B","C")

or

=if(A4="AnyOneOf800Names","B","C")

It's gotten tedious.

First, I can fill in all the names. I'd only need a generic sample of a
handful-- maybe two or threee sample names.
Next, I just need the basic code to connect the names to the dropdown menu.
I've learned that the ActiveX menu is the one that I want to place in the
worksheet.
It appears rather a simple task to insert the menu into the location on the
worksheet.

I just need to know how to connect this: =EMBED("Forms.ComboBox.1","")
to a cell on my worksheet.

I hope that clears it up. If not, please let me know.

Again-- thank you very much.



"dan dungan" wrote:

Hi Steve,

I'm not sure I have the expertise to help and I'm still not clear
about your desired outcome. Here are some questions they may clarify
your goals for the group to offer some help.

Do you want a macro to write the formula to all the rows in 800
workbooks?

Are all the workbooks laid out the same?

If you got this to work, what would that do for you?

I hope this helps,

Dan
.