General question..

[Atholl]

Hi all,
I will be constructing a spreadsheet which performs a set of calculations on some data sets. The (extremely voluminous) data sets have been generated by another program and each, of course, have a criteria distinguishing them from eachother. The size of the data sets varies also.
I want the front end of the spreadsheet to show a list of the datasets so the user can select one and perform the calculations. Alternatively, I'm thinking about a method in which the user can enter some criteria, and the spreadsheet will select the closest dataset to that criteria.
Either way, the data sets have to be within the spreadsheet, and my question is (finally): How can I refer excel to the correct data set, bearing in mind its size is not uniform?
Have I expressed myself clearly?

Thanks in advance,

Atholl

 

[s-o-s]

On 2002-08-27 01:28, Atholl wrote:
Hi all,
I will be constructing a spreadsheet which performs a set of calculations on some data sets. The (extremely voluminous) data sets have been generated by another program and each, of course, have a criteria distinguishing them from eachother. The size of the data sets varies also.
I want the front end of the spreadsheet to show a list of the datasets so the user can select one and perform the calculations. Alternatively, I'm thinking about a method in which the user can enter some criteria, and the spreadsheet will select the closest dataset to that criteria.
Either way, the data sets have to be within the spreadsheet, and my question is (finally): How can I refer excel to the correct data set, bearing in mind its size is not uniform?
Have I expressed myself clearly?

Thanks in advance,

Atholl

Atholl,

I did something like this about four years ago...

Take the entire database and shove it through a pivot table with a single row variable producing just a count of that variable.

Copy the Range to a specific place. Repeat the process for each variable, In my case it was Account, Cost Centre, Division, Product Line, Project ... etc This was then used as feed to drop down menus...This sounds like the sort of thing that you are trying to do.

It was a fairly lengthy bit of code though!!!

Hope this helps.
Sean