Hi,
I need help with my formula
I have attached the excel. The requestor sheet is where the data is entered, so if the requestor chooses Global, all the countires should be automatically picked.
In the creator sheet, the data is reflected and based on that the TAX, VAT and Product is automatically populated and the creator then creates the product for all the countries.
I am stuck with the foumula to auto populate the countries (highlighted in yellow),as one requestor can fill upto 100 requests in a page with many global products as well. Please help!!!
The formula which I have used is not giving me the result I require i.e., not all countires are picked automatically if global is chosen twice!!
Please adivce on the best formula to use
Bookmarks