Excel button to a sheet

Hi,

To navigate between sheets, you have a simple method, hypertext links.
For example, in column A, enter the names of your sheets and right-click on a cell/Hyperlink/select location in this document, click on the sheet to open (you can also choose the cell you want to activate), and so on for the other sheets. You can do the same on each sheet which will allow you to navigate.

You can also select your sheet from a validation list with a little VBA code involved.

With a button associated with a list or a series of buttons, each corresponding to a sheet.

For the follow-up question, please explain exactly what you want to do. I think you want to click on a button and a small dialog box allows you to enter text to fill in a cell, or you click on the button and the content of a cell is copied or cut to another cell.

See you soon!
Mike-31

A problem without a solution is a badly posed problem (Einstein)

Thank you Pijaku for your explanation
I need another little help please
how can I create a dropdown list with the names of the cities
city1
city2
city3
and when I select city 1
I have a table that appears next to it, a table I mean my cells of 5 rows & 3 columns
when I select city 2 another table appears but instead of the previous one
it's like having a display box for previewing the values
thank you

In that case, use the method suggested by Mike-31 regarding hypertext links.
--
Whatever is worth doing is worth doing well.

But actually, I managed to create the hyperlinks but the display doesn't happen in one single place
but in several different places
I created a link and I would like to know how to display cell Z3 for example or cell H5:Z3
that's fine, it's doable
but what I would like to do is to have a single display area and insert all my displays no matter which link I've clicked on.

Re,

If you have already created your hyperlinks,
Right-click on the link Change Hyperlink, in the text box Enter the cell reference, enter Z3 or H5:Z3

See you +
Mike-31

A problem without a solution is a badly posed problem (Einstein)

but the problem is that I have a list of links
when I click on the first link it takes me to the corresponding cell
the second link takes me to the corresponding cell too
but what I'm trying to do is have all my links direct to the same cell but just change the display

Re,

I don't quite understand, do you want all your links to point to the same cell on the same sheet!

See you later
Mike-31

A problem without a solution is a poorly formulated problem (Einstein)

example
link 1
link 2
link 3

Table1
Table2
Table3

when I click on link 1, it shows Table1
when I click on link 2, it shows Table2
when I click on link 3, it shows Table3

but what I would like to do is have my links on the left in a dropdown list
and on the right an DISPLAY AREA FOR TABLES
when I click on link 1, I see Table1 displayed in the DISPLAY AREA FOR TABLES
when I click on link 2, I see Table2 displayed in the DISPLAY AREA FOR TABLES
always on the same page
that way I have a preview of my tables without changing pages and without having to scroll down to the bottom because I have plenty of tables

Hi,
Are your tables 1, 2, 3 fixed in number of columns and rows?
If so, you can create 3 buttons that copy/paste the tables wherever you want.
--
What is worth doing is worth doing well.

Yes, my tables are fixed
How should I do that, but I would like to display all the tables in the right place according to the link I clicked

Hello,
Let's assume that your table 1 is located in Sheet2 Range("AB136:AE146"); and you want it to appear in Sheet1 Range("A1:D11".
You create a small button (commandbutton1) and you type this code:
Private Sub CommandButton1_Click()
Sheets("Sheet2").Select
Range("AB136:AE146").Select
Selection.Copy
Sheets("Sheet1").Select
Range("A1").Select
ActiveSheet.Paste
Range("A1").Select
End Sub
Same for other tables.
--
What is worth doing is worth doing well.