Go to the Query table with a button

[Martin sherk]

Hello All,

i have 4 query tables loaded in my excel sheet under each other, when data varies there are gaps between tables.

is there a way to easily navigate between tables, a button maybe linked to each query table, or a hyperlink. please share your thoughts and ideas.

 

[RoryA]

Why do you do that, rather than just having one table?

 

[Martin sherk]

Why do you do that, rather than just having one table?

Because we separate them by what needs to be paid table, what's paid table, and what needs to be looked into table.

 

[RoryA]

You could add a status column to distinguish them?

You could just use the name box to jump to the relevant one.

 

[Martin sherk]

You could add a status column to distinguish them?

You could just use the name box to jump to the relevant one.

My tables has names, how can i use these names to go to when a button is pressed maybe.

You could add a status column to distinguish them?

You could just use the name box to jump to the relevant one.

they keep it that way for a presentation wise as it looks better in their opinion if it's all seperated in tables.

 

[jdellasala]

You can use the formula

=HYPERLINK("#'Sheet 1'!Table1[[#Headers],[Column One]]", "Go to Table 1")

to create a link to the table. Replace Sheet 1 with the sheet name the table is on, Table1 with the name of the table, Column One with the name of the column you need, and of course the prompt text as needed.

You can always create a button that goes to the Cell Address of the table like A1 which is where that table lives, but I couldn't get a button to take a table reference.