Hi All,
Just needing some help creating a matrix on one of my sheets, I have 3 sheets with different sets of data on them which will then be used to create a matrix style view, please note that the data in worksheets (Checklist, Server_Listing & Exceptions) will be dynamic and new data will be added. In worksheet 'Matrix' I'm needing the formatting done as shown in that tab and the data will need to reference the data sheets and populate, also there are 2 cells on the Matrix sheet which identify which data needs to be shown (Month & Year). Hope it's something easy to do as I'm not too familiar with VBA, I've attached an example. Thanks in advance.
http://www.filedropper.com/book1_4
Just needing some help creating a matrix on one of my sheets, I have 3 sheets with different sets of data on them which will then be used to create a matrix style view, please note that the data in worksheets (Checklist, Server_Listing & Exceptions) will be dynamic and new data will be added. In worksheet 'Matrix' I'm needing the formatting done as shown in that tab and the data will need to reference the data sheets and populate, also there are 2 cells on the Matrix sheet which identify which data needs to be shown (Month & Year). Hope it's something easy to do as I'm not too familiar with VBA, I've attached an example. Thanks in advance.
http://www.filedropper.com/book1_4
