Identify source of cells

wideboy - Feb 10, 2016 at 09:14 AM

I've got a spreadsheet which reads cells from 9 other spreadsheets one of two tabs in a very large list. Other users copy and paste cells between the two tabs within each of the 9 spreadsheets

I want to check that the right cells have been sourced in the right places in my spreadsheet.

Is there a formula which I can use and input into my spreadsheet which can identify the source of the cells and display it so that I can check if the right cells are being sourced in the right order?

e.g. cellA1 is sourced from file1 tabA, cellA2 is sourced from file2 tabA, cell A3 is sourced from file2 tab B, etc etc