I'm working on an excel document where I'm referencing another sheet. The columns in the sheet that I'm working on contains the same formula only the letter changes.
=Sheet7!C$16/Sheet7!C$21 =Sheet7!D$16/Sheet7!D$21 =Sheet7!E$16/Sheet7!E$21
etc. However Excel won't let me drag this down and I don't want to have to do this by hand 100s of times. Any help is appreciated.