Listbox question, IDEAS?

[Lexje]

Hi Folks,

This is an odd on, probably not undoable, but I have no clue where to start, so ANY suggestions WELCOME!!

Here goes the description:

I have 10 sheets in a workbook. They contain information about countries. Each sheet represents 1 year. Every row in a sheet represents 1 country.
Every row/country record contains 29 cells / fields.

All userinput happens via userforms, there is no direct input allowed.

It is important to realize, that a sheet may be empty; a sheet may contain only 3 rows.

Now I come to my point:
6 of the 29 fields will have to contain an appreciation value from 1 - 10.

I'm looking for a GOOD way to get these numbers in the corresponding sheets.
I was thinking of this:
Userform with a couple of listboxes;
One listbox will contain the 'eventual' present countries. (May be 3 maybe 246!) (Scrollbar)
Another listbox or some fixed buttons from 1 - 10;
User should then first select appropriate country;
Next press button with appreciation,
Choice is copied to corresponding cell.

Looking forward to your ideas!!
Thanks!!

Erwin

 

[BrianB]

In the absence of other replies :-
Looks everso complicated. Too much for my poor head.

I suggest you put all your data in a single table in a worksheet with an additional "Year" column and use Data/Filter/Autofilter.

Or something.