asked on 5/16/2011

Use excel query parameters to also be column header

Hi all.

I have an excel 2007 file whose data source is a sql table. When the user opens the file it asks them for 2 parameters how can have the 2 parameters the user enters appear as a column header using vba?

Thank you in advance!

Microsoft Excel

Last Comment

Rory Archibald

5/16/2011

ASKER CERTIFIED SOLUTION

Rory Archibald

5/16/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

printmedia

5/16/2011

ASKER

Thanks for the reply. Currently, when the file is opened by the user it prompts the user for the 2 parameters.

So what you're suggesting is that I put the parameters in a cell?

Rory Archibald

5/16/2011

Yes. If you right-click the table, choose Table-Parameters... you should be able to choose cells as the input ranges and also specify that the table should update automatically if their values are changed.

Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K

Questions

Followers

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY