macro question with degree of difficulty

[ass98]

i need a macro to basically generate a fixture list for any sporting event.

i just want it to generate the numbers not team names e.g 1 v 3, 5 v 25

can any one help?

 

[Dave Patton]

On 2002-09-01 09:17, ass98 wrote:
i need a macro to basically generate a fixture list for any sporting event.

i just want it to generate the numbers not team names e.g 1 v 3, 5 v 25

can any one help?

two points

1. your subject is not very informative

2. your question is not clear
You will get much better results if you describe what you require, provide a very concise example, and mention what you have already tried.

 

[ass98]

its for a pool league.

heres how it goes:
------------------

1. input a number in cell A1 (e.g 4)
2. macro will generate a fixture list for the number in cell A1
3. the generated content will be placed in seperate rows and columns e.g B2=1, C2=3,B3=2, C3=4 and so on.

so then the output will look like this:
1 3
2 4
1 2
3 4
1 4
2 3

 

[ass98]

come on some one must know!

 

[stevebausch]

I found this, searching on "generate fixture list":

http://www.jwr-software.com/feb2001release.htm

and this

http://www.ultrasoftware.net/archive/fold/detail579.htm

I still don't know what a fixture list is, most Yanks won't.
This message was edited by stevebausch on 2002-09-01 11:16