# =GetGP(), the Excel Function that gets data from Dynamics GP database into your spreadsheet, one cell at a time. – ERP Software Blog

- URL: https://dynamicaccounting.net/getgp-excel-function-gets-data-dynamics-gp-database-spreadsheet-one-cell-time-erp-software-blog/
- Date: 2017-04-13
- Topics: Excel & Office
- Type: link to an external article
- Source: http://mobile.erpsoftwareblog.com/2017/04/getgp-excel-function-gets-data-dynamics-gp-database-spreadsheet-one-cell-time/

> [![](/wp-content/uploads/2017/04/GetGP_SampleSpreadsheet-1.jpg)](http://mobile.erpsoftwareblog.com/2017/04/getgp-excel-function-gets-data-dynamics-gp-database-spreadsheet-one-cell-time/)=GetGP(), the Excel Function that gets data from Dynamics GP database into your spreadsheet, one cell at a time. At times we need the ability to bring a value from GP into excel, primarily because it could change or to verify if a key is valid. This is a very simple way to provide the much-needed functionality …

This is an interesting post from Titanium GP. It’s code to create a custom function to make it easier to pull data from GP into Excel.

*[=GetGP(), the Excel Function that gets data from Dynamics GP database into your spreadsheet, one cell at a time. – ERP Software Blog](http://mobile.erpsoftwareblog.com/2017/04/getgp-excel-function-gets-data-dynamics-gp-database-spreadsheet-one-cell-time/)*