Hi Guys,
To explain to you my process
I have an email that comes through with a spreadsheet attached
The spreadsheet that comes through is dynamic, the worksheet tabs can be called different things and the cell locations differ.
I want to extract only certain information but don't know where that information will be each time
This is the top of the collection
View attachment 1560334393754.png
Then this is some data further down
View attachment 1560334237728.png
I want to extract the data highlighted in yellow and the data hidden in red.
View attachment 1560385523025.png
To explain to you my process
I have an email that comes through with a spreadsheet attached
The spreadsheet that comes through is dynamic, the worksheet tabs can be called different things and the cell locations differ.
I want to extract only certain information but don't know where that information will be each time
This is the top of the collection
View attachment 1560334393754.png
Then this is some data further down
View attachment 1560334237728.png
I want to extract the data highlighted in yellow and the data hidden in red.
View attachment 1560385523025.png