I have a web page with an HTML dropdown box where users select from among various cities, e.g. Atlanta, New York, Los Angeles, etc. The desired output is a table and charts with data for that city.
I already have a spreadsheet called City.xls set up with the underlying data.
In City.xls, cell C3 of the worksheet called "Output" runs the whole show. If you put "Atlanta" in that cell, it uses lookup, other functions, and pivot tables to generate data and charts for that city. I have already used an Excel dropdown in this cell so I know the spreadsheet works when the correct value is entered in cell C3 of the Output worksheet.
Currently on the web page, I have the option value "Atlanta" opening up the City.xls spreadsheet. It opens with a default value in cell C3 (not Atlanta). I would like to know how to get "Atlanta" into cell C3 on the spreadsheet to produce the correct output when someone selects "Atlanta". If someone chooses "New York", I want that same spreadsheet (i.e. City.xls) to open with "New York" in cell C3 and thus produce the correct output.
Can someone tell me how I might accomplish this?
I already have a spreadsheet called City.xls set up with the underlying data.
In City.xls, cell C3 of the worksheet called "Output" runs the whole show. If you put "Atlanta" in that cell, it uses lookup, other functions, and pivot tables to generate data and charts for that city. I have already used an Excel dropdown in this cell so I know the spreadsheet works when the correct value is entered in cell C3 of the Output worksheet.
Currently on the web page, I have the option value "Atlanta" opening up the City.xls spreadsheet. It opens with a default value in cell C3 (not Atlanta). I would like to know how to get "Atlanta" into cell C3 on the spreadsheet to produce the correct output when someone selects "Atlanta". If someone chooses "New York", I want that same spreadsheet (i.e. City.xls) to open with "New York" in cell C3 and thus produce the correct output.
Can someone tell me how I might accomplish this?
Comment