Hi!
I have a workbook with a bunch of datasheets. Most of the columns in the datasheets are not being referenced in the summary sheet. I am currently editing the queries so that unused data is no longer pulled.
Is there a quick and easy way to use Excel to highlight my datasheets to show which columns are referenced in formulas and which are not?
Thanks!
Bookmarks