I would suggest you buy a loading manual, I recommend Sierra, as they don't make powder, so they have lots of loads for all the powder manufacturers. Later on pick up Hornady, Lyman and Speer
I also suggest that you try to match the caliber to the typical powder that is used. This is automatically done in the loading manuals. Rifle powder is generally too "slow" for pistol loads. DO NOT try to "force" a powder to fit your caliber.
I recommend you consider Bullseye powder for your 9mm and your 45ACP. It also works well in 38, 40S&W, 45acp and 9mm light and medium loads. (it is not used for the maximum loads in these calibers)
It is a very fast powder, takes very little powder to make a charge, and you must be careful you do not "double charge" a case. There are some more modern powders for the light and medium pistol charges, but I have no experience with them.
I HIGHLY recommend you start with a mild load. DO NOT start with a maximum load.
Also, when discussing a pistol load, list the following:
Caliber
Bullet weight and type (round nose, semi wad cutter, etc.)
Bullet is lead, or jacketed
Primer size and manufacturer, ie, Winchester SP (small pistol)
Powder
Powder weight in grains
Intended use, ie, plinking, target shooting, IDPA, hunting, self defense
With this info on a load, members can make a more informed suggestion.
Welcome to the Accurate shooter website, and to starting in reloading