Forum Discussion
Creating a master sheet which includes buttons with links to certain cells
NikolinoDE Thanks for response but I think you misunderstood what I was asking. So here's what I'm trying to do.
1. Insert a shape and put on a blank excel file. We shall call this the master list
2. On the box itself right click and go to link
3. Go to Place in this document
4. In the box type the cell reference on top put the cell you want the button to go to
5. Right below that it says select a place in this document and choose the worksheet thats your masterlist
6. Now make a copy of the worksheet and name it January.
Here is where I'm having my problem. If you click on the box to go to the cell you want it goes back to the master list not the worksheet named Januart bc the original link was created in the master. I have 76 buttons and I cant sit here and edit everyone for all 12 months it will take alot of time. Looking for a quicker way
In advance, with your permission, I would like to recommend an update and, if necessary, an office repair. At the same time, it would be very useful to know the Excel version, operating system, storage medium (OneDrive, hard drive, Sharepoint, etc.).
In addition, add a file (without sensitive data) or photos (if they help the task) and explain your request step by step on the basis of this file.
Thus you can get a faster and more precise solution proposal.
At the same time, the helper can focus the available time on the problem / topic without necessarily having to guess.
The file with the example is included, I don't know whether this will help, but it is worth a try :)).
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)