Excel Template -- Using Information based on a Field

smoskowitz

Hi All --

I built a workflow that pulls information from approximately 325 spreadsheet templates. Most of the templates have a single tab. However, some templates have multiple tabs of data with a third tab (or more) summerizing the data. This is causing me an issue as I am doubling up on some of my numbers.

What I noticed is that there is a field in the data tabs called Full VA? that doesn't exist in the summary tabs (see images below). The coordinates  (using the @Joe_Mako Cleaning messy Excel Data method is Record 5 Name 1.

I am trying to figure out how to use information from spreadsheets that have a Full VA?  at record 5 name 1 -- but keep hitting a dead end.

Thanks,

Seth

Summary tab

Data 

TX_6 Workflow.yxmd

169710 - Lowe Investments - TX-6 2015 Standalone.xlsx

184000 Lowe Turkey - TX-6 2015.xlsx

Joe_Mako

Attached is your workflow edited and the missing macro so anyone else can open your original workflow.

Also attached is this alternate approach:

After the loading:

- Filter tools to grab the values of interest

- Join match up the field names and field values

- Cross Tab to create the normal data structure

- Join the two constructed data tables together

Is this what you are looking for?

Load Macro.yxmc

TX_6 Workflow JM Edit.yxmd

TX_6 Workflow.yxmd