Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi
i would suggest setting up a MS Query and tie the refresh to your button. or there is a refresh icon on the external data toolbar that could be used also. on the menu bar.... dataimport external datanew database query. follow the wizard. regards FSt1 "Ryan H" wrote: I have a spreadsheet that contains part numbers (Col. A), description (Col. B), and cost (Col. C). I would like to click a button and the descriptions and costs of each part number will be updated automatically from the SQL Database. What would be the best way to go about doing this? Thanks in advance! -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keep data in fields if no update while updating | Excel Worksheet Functions | |||
Can I pivot multiple data fields and display them in a column? | Excel Discussion (Misc queries) | |||
Splitting Column Data into 2 fields | Excel Worksheet Functions | |||
function to show if two fields in a column have the same data. | Excel Worksheet Functions | |||
How to get data from pivot table with multiple column fields? | Excel Programming |