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 

[Joe_Mako · Accepted solution]

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?

[smoskowitz]

I altered your solution to fit into my current workflow. This was awesome @Joe_Mako. Thank you!