Jonathan Griffin
New Member
Hi,
Is it possible to specify one excel sql parameter that reads from a particular cell regardless of the sheet I am working on.
For example, I am working on Sheet 1 and cell H14 is what the SQL database is using as a parameter. If I move to Sheet 2, I want cell H14 to be the new parameter.
The cell will always be H14, and I want to only have 1 sql connection, is this possible?
Is it possible to specify one excel sql parameter that reads from a particular cell regardless of the sheet I am working on.
For example, I am working on Sheet 1 and cell H14 is what the SQL database is using as a parameter. If I move to Sheet 2, I want cell H14 to be the new parameter.
The cell will always be H14, and I want to only have 1 sql connection, is this possible?