Your cable modem should have a cable connector and a network connector; it also has two addresses - your public (Internet) IP address, and an internal IP address. Instead of plugging the network port into a PC, connect it to a cheap hub or switch and connect both PCs to the same hub/switch. Set up the modem to handle all the PPoE username/password stuff your ISP requires, and enable it to serve as a DHCP server. Most do this as a default. Configure TCP/IP on the two PCs to obtain settings automatically. This allows them to ask the cable modem for a local IP address and a gateway, and also lets the modem determine the DNS servers to use for Internet name resolution.
This should allow you to access your Internet connection from either PC, even if one is turned off. One thing to be aware of is that when you configure your cable modem settings, you must direct your browser to the internal IP address on the modem (usually found in the setup instructions from your ISP), and the request must come from a PC on the same subnet as the modem. This means that you may have to intially configure one PC with a fixed IP address to talk to the modem. For example, if the modem configuration address is 192.168.254.254 (typical for a SpeedStream DSL modem) you must have the controlling PC manually set to an address of 192.168.254.X, where X is any value other than 254, except 0 or 255; I use 100 out of long habit. The subnet mask is usually 255.255.255.0.
Once you have the modem set correctly, then you can set the PC for automatic configuration and let the modem assign addresses on your mini-LAN.