Forum Discussion
Linking two spreadsheets with text data and from multiple sheets into one
I know it is possible to link spreadsheets using a simple = if the cells are to remain in the same place, or to use consolidate if you wish to summarise numerical data, but in my current job role, we...
You could use Data, Get Data, From file, From Workbook for this purpose. You can then make sure the name of the tab is there as a separate column. Also, you can filter the table before it is sent to the worksheet so you can omit anything you don't need. But there is a problem: If you add any comments next to the resulting data, a subsequent refresh of the data removes all comments (unless you make this a tricky to setup, self-referencing query to get the comments back).