Simple Case on Excel Spreadshhet

[Pelson2003]

I need a vb program on excel .. I think we can use a simple but very long Do case.

1) First Spreasheet ( I will enter with a option 1 to 100 )
in a lot of cells.

2) Second Spreadsheet I will Have 100 Fields

1- I will need a do case and will test the 1-spre
2- asheet and for each valor equal to 1 , 2 ,3
3- 4 .. I will add 1 in the respective colum in
4- spreadsheet 2. I think this is easy but very
5- long
.
.
.
.
.
etc.

If anyone has any question about this please let me know

Nelson

 

[xlbo]

This is not a helpdesk. People are not here to do your work for you.
What have you tried so far. What specific problems do you have ?? These are the kind of question that will get answered here
"Write some code to my specification" will not

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question