S
Steve
If I have a workbook with 7 sheets in it, e.g.
violet,indigo,blue,green,yellow,orange and red.
And data is in the A column of each sheet.
E.g. violet
1
2
3
4
blue
3
green
2
3
On an 8th sheet, I'd like some sort of table that will show when there is
matching data on the different sheets, something like this:
sheet names violet blue green
violet match in blue match in green
blue match in violet match in green
green match in violet match in blue
Thanks,
Steve
violet,indigo,blue,green,yellow,orange and red.
And data is in the A column of each sheet.
E.g. violet
1
2
3
4
blue
3
green
2
3
On an 8th sheet, I'd like some sort of table that will show when there is
matching data on the different sheets, something like this:
sheet names violet blue green
violet match in blue match in green
blue match in violet match in green
green match in violet match in blue
Thanks,
Steve