I've seen this done before and cannot for the life of me remember how to get it up and running, so what better place to ask after being a lurker for the last 10 years or so.
Problem
I am looking to create a solution that allows me to pull specific data from cells that allows me to create reporting in text format, ideally with the cell headers corresponding
I-e -
Customer - John
Project Scope - New install
Date requested - 1st May 2021
Customer - Alice
Scope of Work - Repair
The above example is just an example I created to give an idea of what I am looking for in theory.
Also an added issue that not all information in the workbook is relevant. For each row of around 100 cells, there are maybe 20 cells that would be relevant to the scheduling ticket this is looking to create.
I know there is a few ways of doing this, so any suggestions would be much appreciated.
Problem
I am looking to create a solution that allows me to pull specific data from cells that allows me to create reporting in text format, ideally with the cell headers corresponding
I-e -
Customer - John
Project Scope - New install
Date requested - 1st May 2021
Customer - Alice
Scope of Work - Repair
The above example is just an example I created to give an idea of what I am looking for in theory.
Also an added issue that not all information in the workbook is relevant. For each row of around 100 cells, there are maybe 20 cells that would be relevant to the scheduling ticket this is looking to create.
I know there is a few ways of doing this, so any suggestions would be much appreciated.