Take cell in first worksheet and subtract using a number from another worksheet

Copper Contributor

I wanting a formula to put for my cells in which C15 on worksheet one is subtracted by a number on worksheet two. So that when I update worksheet two, worksheet one is automatically updated. I have figured out how to do it manually by =C15-and then left clicking on the cell on worksheet two. But this does not stick, and I will have multiple columns and lines to do this to.

I am not familiar with excel lingo anymore as it appears my skills have faded over the years from not being used. Sorry..

0 Replies