VBA Copy & Reference from Sheets & Create Matrix

Joey86

New Member
Joined
Jul 25, 2013
Messages
32
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
 

Forum statistics

Threads
1,082,551
Messages
5,366,276
Members
400,881
Latest member
DevelopedUnkown

Some videos you may like

This Week's Hot Topics

Top