I have an excel workbook with three worksheet namely Document_CH587, Shell and Total.
Document_CH587 is the main worksheet where I filter out data for shell and total respectively as you can see below.
So I go ahead and create an invoice for each but the workflow for creating the invoice is the same for both(Shell and Total), but the sale details differ.
Is there a way I could read the worksheets and if they’re equal to Shell it operates a certain way as well as for Total.
Hope am clear enough.
Kakooza Allan Klaus