1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Assign names to values

I’m working on a hobby project, an excel workbook that will automatically calculate some chemistry maths. As part of this I have a list of elements and their atomic weights that I would like to refer to in formulas as their element names rather than the cell name.

How can I assign a name to each value that can be used across multiple sheets? I’ve researched so much I’ve confused myself haha. Any help is appreciated!

submitted by /u/local_scientician
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article