Excel VBA request
Posted on 2016-09-29
I have multiple excel sheets in a workbook. Each sheet has same column and row headers (same field area)
Each sheet has 'X's in the field where something exists, like a mapping. What I need is a MASTER sheet that consolidates all of the X's and overlays them in the same field area. I see VBA that consolidates sheets into one, but they don't overlay the data but rather line up the sheets horizontally.
If sheet A has an 'X' in B2 and Sheet B has and 'X' in B3 but not B2, the result would be 'X's in both B2 and B3 in the MASTER. (Ignore the blanks)
Thanks in advance!