Have uniqueid() in main table ID key
How to auto fill that ID same workbook ID key to all the other tabs in the workbook?
"Mapping" meaning matching column data, nothing to do with maps or gps or XY.
-----------
After that wish to "map the data" from the "main" sheet to the other tabs which have different headings, except for the ID Key which I want the same across all the tabs.
Once again get confused if a ref should be made using the ID? tried this ref and use [ID].[TITLE] in formula, but nothing happened.
What is the simplest least power hungry way to do this as I'm sure multiple ways to get to the same solution.
Looked at Lookup() and Select() but these seem like they are probably not necessary.
Rows Need to stay accurate if a row is deleted.
LinkedIn
Twitter
