Wizards are good when they work but not much use when they dont.
Routers and modems are subtely different beasts as I'm sure you know. The modem will have an IP address that will work for 1 device. Your router - if its the right kind - will let lots of devices use that 1 IP address and hide all the workings from the modem.
Why do I say "if its the right kind"? Well - there are lots of types of router. Most that you'll find at PC world or wherever wont be the type you need. You need an ethernet to ethernet router, not a dsl router as nearly all of them are.
Typically the router will have 4-8 RJ45 sockets on the back and telephone cable socket seperated by an inch or so. the type you need instead of having thta telephone port will have another RJ45 port. Its that single port that the modem needs to be attached to. I suspect at the moment its in the main bunch of sockets with the PC's.
Have a look at the PC that works and find its IP address... if its not a private IP like 192.168.0.2 or 10.0.0.2 but more something like 83.90.246.73 its using the address that the router should be using.
How should it be set up? Well the modem should go into the seperate port and its external IP programmed to match that given by the modem (that IP will look complex and random). The internal side of the router should than be programmed to give out DHCP addresses in the 192.168.0.x range or similar. All the PC should be setup to auto matically get their IP's and itr should work.
What if you dont have the right router? Well - your PC can act as a router if you put a second network card in it. Connect card 1 to the modem and card 2 to a hub or switch where the others can connect and run the network connection sharing wizard. Then you may need to manually set the IP's for the other PC's to match the range set in connector 2 of the routing PC.
Once you have teh wired PC's all working happily the wireless should be straightfoward - but leave that till everything else is working.
Good luck.