Avatar of hardybj

asked on 

Excel VBA request

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!
Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon