Integration Excel Macro

Overview

Create a macro to take data from one row and transpose it to columns for use with Integrations in SmartConnect.

Solution

The originating data is shown below

1
Using VB in excel we have created code to copy, paste & transpose the data. Sample code is below

2

The way that we have designed the macro keeps the original data and pastes the information on to a new sheet. The macro has also been designed to place protection on the excel workbooks preventing any formulas being amended accidently and runs at a good pace.

With the data being in the new format it will enable us to integrate in to GP using SmartConnect and save us from having to manually re-type large amounts of data.

3