Hi there! I really need your help. Is there a macro that could do the following:
I have a worksheet full of formulas (sumifs, index(matches), etc). These formulas pull from 4 worksheets of source data in the same workbook.
What I want to do is that if a user double clicks on any cell with a formula, it will open up a new worksheet and will display only the source data that was used to calculate that number (similar to what pvt table does)? The reason I don't want them to see all of the data is because various users have different rights to what they can see.
Thank you for any help!
Bookmarks