Finding the Difference in workbooks.

To track changes in resources between two separate workbooks in Excel, you can use a combination of functions like `VLOOKUP`, `INDEX`, and `MATCH`, or you can utilize Excel's Power Query functionality. 

This is 1 of the alternate which you can try. Assuming you have Workbook A (previous day's report) and Workbook B (current day's report):

1. Open Workbook A and Workbook B in Excel.

2. In Workbook B, create a new column (let's say it's in Column C) where you want to track changes (e.g., "Status"). In this column, you can use formulas to find differences between the two workbooks.

3. To check if a resource from Workbook B exists in Workbook A, you can use the `VLOOKUP` function. In cell C2 of Workbook B (assuming the resource names are in Column A of both workbooks), enter the following formula:

```excel
=IF(ISNUMBER(VLOOKUP(A2, 'Workbook A'!A:A, 1, FALSE)), "No Change", "New Resource")
```

This formula checks if the value in cell A2 of Workbook B exists in Workbook A. If it does, it marks it as "No Change," otherwise, it marks it as "New Resource."

4. To track resources that have moved from one incident to another, you can add another column (e.g., "Incident Change") in Workbook B. In cell D2 of Workbook B, enter the following formula:

```excel
=IF(ISNUMBER(MATCH(A2, 'Workbook A'!A:A, 0)), "No Change", "Moved")
```

This formula checks if the resource in cell A2 of Workbook B is also found in Workbook A. If it is, it marks it as "No Change," otherwise, it marks it as "Moved."

5. After applying these formulas to the relevant columns in Workbook B, you can visually identify which resources are new, which have moved, and which haven't changed based on the values in the "Status" and "Incident Change" columns.

Kindly adjust cell references and workbook names to match your actual data and workbook structure.

Alternatively, you can explore Excel's Power Query functionality to combine and compare data from multiple workbooks, which can provide a more automated and flexible solution for tracking changes between the reports. 

Scales1270 

Please consider giving it a 'thumbs up' if the response was helpful for you. (external links removed by moderator)