Thread: CrossTable Referencing To List
View Single Post
 
Old 03-20-2018, 09:16 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
I believe the macro in the attached does what you're after although the results don't match your handmade results.
Sheet "Mal (2)" is the handmade results with the differences highlighted. I'll leave it to you to check into these.
Attached Files
File Type: xlsm sample.xlsm (198.0 KB, 14 views)
Reply With Quote