Forum Discussion
Creating a master sheet which includes buttons with links to certain cells
Create an external reference (link) to a cell range in another workbook
Create a link to another worksheet
Select the cell or cells where you want to create the external reference.
Type = (equal sign).
If you want to use a function, such as SUM, then type the function name followed by an opening parenthesis. For example, =SUM(.
Switch to the worksheet that contains the cells that you want to link to.
Select the cell or cells that you want to link to and press Enter.
Note: If you select multiple cells (=Sheet1!A1:A10), and have a current version of Microsoft 365, then you can simply press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by pressing CTRL+SHIFT+ENTER. For more information on array formulas, see Guidelines and examples of array formulas.
Excel will return to the original worksheet and display the values from the source worksheet.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
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)