I am using Excel to grab a table on a web page
Date > Get Data > From Other Sources > From Web
The URL of the page is along the lines of
internalsite/inspection.ext?=11023
"11023" is the ID that calls out the record set that gets stuffed into the table I'm pulling into Excel. I would like to make it easy for standard users of this sheet to enter an ID number so excel can fetch the record they want.
What's the best way (easiest on novice users) to accomplish this?
THANKS!
Bookmarks