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

how to define a name for specific word in a column, that also expands whenever I add more?

So, I have a column called element name and defined a "element.name", and under it there Water, Fire, Earth and Air. Can I select "Element Name" column and define a name but only for entries with word "Fire"? also I need something dynamic, whenever I add any entry with "fire" it'd also add it automatically to the name definition.

hopefully I explained this well lol. Also I preferred to use Avatar as a reference instead my real company for idk why :D

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

Want to read more?

Check out the full article on the original site

View original article