Hi all!
This is my first post on here so I hope someone can help me out!
I have a pivotchart in Excel and when I use double click it brings me to a new sheet what is nice.
Now I want to link some cells in a new sheet with this pivotchart by using a hyperlink (right mouse click on the cell and then hyperlink wit pivotchart cell) and I want it to be able to pull the formula down so i don't have to write everything manually. I will show what I mean exactly by the following pictures. So i want it to be linked automatically by hyperlink with the cell it says in the 2nd row. So in the picture it is already written by hand and that is why it works but i would want Excel to do this automatically. It is possible to make a hyperlink that is linked ot a cell and then pull it down so the other values can also link but the problem is that it is linked with a cell and i couldn't be able to figure out if it is possible. Can someone help me out with this problem? It would save me a lot of time!
This is my first post on here so I hope someone can help me out!
I have a pivotchart in Excel and when I use double click it brings me to a new sheet what is nice.
Now I want to link some cells in a new sheet with this pivotchart by using a hyperlink (right mouse click on the cell and then hyperlink wit pivotchart cell) and I want it to be able to pull the formula down so i don't have to write everything manually. I will show what I mean exactly by the following pictures. So i want it to be linked automatically by hyperlink with the cell it says in the 2nd row. So in the picture it is already written by hand and that is why it works but i would want Excel to do this automatically. It is possible to make a hyperlink that is linked ot a cell and then pull it down so the other values can also link but the problem is that it is linked with a cell and i couldn't be able to figure out if it is possible. Can someone help me out with this problem? It would save me a lot of time!
