I have an Excel spreadsheet with calculations for creating sales quotes. I have Microsoft Accounting 2007 with SQL Database. I currently manualy enter parts, descriptions and price into my Excel spreadsheet. I want to be able to search for parts from my sql database.
Need a search tool on my excel sheet that I can search by Catagory, Manufacture or Part No. (or key word). The serarch list will display, then I want to select and load to my spreadsheet. The loaded fields will be i.e.; Part No., Manufacture, Description, part price, installation time.
I do not want to save the all of the database loaded in my excell sheet when I close it. I only want to save to file only the selected items. the selected item (list) will show in the spreadsheet.
I am interested in a web application that would recreate my Estimation Model with the calculations that are required. This can be an additional porject or upgrade to same.
接包方 | 国家/地区 | |
---|---|---|
![]() |
3
Cmaxo
(中标)
|
|
![]() |
2
Codingandroid
|
|
![]() |
2
Powerteam001
|
|
![]() |
2
Tamnvpt
|
|
![]() |
2
Illusiondesigners
|