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

CNC operator here. Looking for help on an extra parts log and using a single tag in one cell to reference a different sheet and cell with multiple tags within a single cell.

I’m building a list of extra parts along with a long of all nesting programs that I make. Currently when I create a nesting program I have a tag like “52 V Marsh”. When I enter on my nesting log (sheet A) into the appropriate cell at the beginning of my nesting, any part in my extra parts log (Sheet B) with the same tag will appear on Sheet A further down the row (lets me know to not cut the part and notify people we have one in extras). My issue come in whenever we have parts that can have many different tags in a single cell. Like “V Marsh, 42 V, 48 V, 52 V” that all need to be in the same cell on sheet B so that any one of those tags being put into sheet A would reference back to it. Any tips?

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#financial modeling with spreadsheets
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#row zero
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#CNC operator
#nesting programs
#extra parts log
#sheet A
#sheet B
#tag
#multiple tags
#reference
#cell
#parts
#cell referencing
#log