Hi all
I'm a first timer to this forum and rather an amateur at Excel. I was wondering if there was a way to link data in Excel via "button" or a some other link so that if some one clicks on that cell it will redirect to another cell. For example if I put an organizational chart in a range of cells is there way to link one of the boxes in the chart to a group of cells. Thus is some one clicked on "Event Infrastructure" on sheet 1, it would take automoatically take them to the data related to that on sheet 4. Any info would be appreciated.
Cheers
Leon
I'm a first timer to this forum and rather an amateur at Excel. I was wondering if there was a way to link data in Excel via "button" or a some other link so that if some one clicks on that cell it will redirect to another cell. For example if I put an organizational chart in a range of cells is there way to link one of the boxes in the chart to a group of cells. Thus is some one clicked on "Event Infrastructure" on sheet 1, it would take automoatically take them to the data related to that on sheet 4. Any info would be appreciated.
Cheers
Leon