Passing Multiple Parameters to 2 tabs in excel workbook for querying data using ODBC connection

[dippydodda]

Hello Guys,
Apologies in advance if this is a repeated question, i think i did a quick search and was not able to find perfect answer for what i am looking for.

I am pulling the data to excel using ODBC connection (procedures) . I was able to successfully get the data by passing the necessary parameters.

I was able to pull the data for multiple tabs by passing the same parameters again which are referenced in tab1 and tab2.

I am looking for a way for user not to pass in the parameters multiple times if the same input parameter is required in both tab1 and tab2.

Any help on this would be greatly appreciated.

Thanks & Regards,
Praveen Dodda