Excel Data Upload Changed and Need Rewrite

[joewood]

Hi all. Thanks so much for all of the help in the past. You guys are great.

We had a basic database upload which had an Excel program written around it that pushed out several reports.

The database information has changed dramatically in one category and the old sheets no longer function properly.

I've attached the 3 new databases (aaaOptions, aaaItems and aaaOrders) and the old workbooks (!!!Final Working Copy and "Combined Upload Sheet). The problem is basically that the "E" column in the "Initial Combo" tab of the "Combined Upload" workbook is pulling in the wrong data. It used to be a simple, one word text answer (which came from the "aaaOptions" workbook in the F column - for instance "Basile" shown on row 7). But, we added more options. Now, it cannot pick out the proper text line which should be preceeded by the "Enter Script here...".

If you have any ideas how to help us, would you please let me know?

Thanks!

[joewood]

Here are the Excel sheets.

[joewood]

Is this in the right section?