Hi Community,
Our business sends out an empty excel template to applicants. The file has multiple excel sheets depending on the type of work. The applicants add the prices in the template and send it back to us. My end goal is to extract pricing from all the sheets.
I am attaching 3 sample submissions data for it to make sense of the output I am looking for. Each submission has 4 sheets. The applicant's name is on sheet 1. all other sheets have pricings in them.
I have tried the input tool but that's very limited in functionality. I have to specify every sheet in every submission. I have a total of 150 submissions that have 18 sheets in each.
