Filepath part 2

[AntlRo]

 I want the workflow to read 3 out of 7 tabs from the latest spreadsheet "Appleproducts 02-19_2023" that has a product number column that I can join to our Database.

The Column in each tab  is called " Product Number" and some of the rows have multiple values (separated by a comma) as such :

Product number:

Apple-1234

Oranges-579, Prunes-987

Peaches- 789, Mangos-321

output:

Product number:

Apple-1234

Oranges-579

Prunes-987

Peaches- 789

Mangos-321

• I grab that newly output to pull data from our  db as a join  I believe with those exact values which would give me a bunch of new updates and columns etc...  (example our  database already has that "product number" column with the value " Apple-1234""

[binuacs · Accepted solution]

@AntlRo This can be achieved by using the bath macros, the first batch macro pulls all the sheet names, and the second macro extracts the records