•1 min read•from 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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#google sheets
#excel
#workbook
#chemistry
#element names
#atomic weights
#formulas
#cell name
#assign names
#multiple sheets
#hobby project
#calculate
#values
#research
#list of elements
#maths