I have a pivot that I use so the data will refresh once the workbook is opened. This pivot down the left contains sales-reps names (over 1500) and across the top contains a list of items the company sells (over 3000). All of this is on sheet1, sheet2 contains the pre-formatted (which of course never matches up with sheet1) sheet of how the data needs to be presented. I have been just manually matching up the data using cell references, but this has grown to be TOO large of a workbook for me to do this when either a new product is added or a new employee is added. Is there a way for me, through VBA or a different cell reference to match up worksheet2 with the figures on worksheet1?
I am attaching a very very small snippet just so you can get a feel of what I am talking about and hopefully provide some options.
Thanks in advance for helping guys, it is SOOO appreciated.