Required data in different TABS

Question

Hi Team,

I have two outputs " Recal & SAP Data" in recal file we have "Y & N" in I column "highlighted in Tellow". with the help of I column i need "N" data from SAP Data on the basis of "13 Digit ISBN" in C column. Mean need to filter on "N" then VLOOKUP to SAP data based on "13 Digit ISBN" . In SAP data file we have "WBS Reference 2" in D column. if we got the data then in SAP Data file i need "Kategorie" which is in "E" column only "WIP PPB & WIP PPB Variance Acc" those two categories. That data i want in different tabs based on "WBS Reference 2". suppose we got the data "9783527723485, 9783527414048" for these "WBS Reference 2" that data i need it separate tabs.

Regards,

Mahesh

Recal.xlsx

SAP Data.xlsx

OTrieger · Answer

Cool

Maheshp · Answer

Thank you for the suggestion, it has been resolved.

OTrieger · Answer

@Maheshp 
You can define the path name including the tab name. will be able to do it in several ways, with a batch macro or multiple output tool, but then you will need to use Stop until done to ensure a synchronized saving of the same file with the different tabs. To define the tab name you will need to use the following format "//.../.../filename.xlsx|||tabname"