Let's say cell K1 has your state sales tax, say 7%
So in a formula you might have =A10*K1 to compute the tax on an item
If you give K1 the name of "tax", you can use =A10*tax
After giving the call the name you can edit the cell with =A10*K1 and use
apply to have it change to =A1*tax
Paste just pastes then name
Now would be a good time to get an Excel book and read more
Notwithstanding the Web, books are not obsolete yet
Or you could Google for "excel name"
best wishes
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.