Hi,
Please help!
I have a file with multiple sheets. The same products, but from different countries so they have 70% the same names. They all have different prices but in the same currency. I need to be able to have the first row with my name of the product (the one that I set), my price in the second row, and from there (3rd row, 4th, and so on) the price that every customer offers. Starting with the best (calculated in percentage from my price).
So basically I have my price with my name of the product, and I need to see which one of my clients has the best price on offer.
It would be great if I can just input the clients list somewhere (on a different sheet) and it will give me the updates result in the first sheet. This is because every month (sometimes twice a month) prices may change.
I know it is pretty darn complicated but I even tried paying for this and didn't manage to find the answer...
Thank you in advance for any possible solution
Please help!
I have a file with multiple sheets. The same products, but from different countries so they have 70% the same names. They all have different prices but in the same currency. I need to be able to have the first row with my name of the product (the one that I set), my price in the second row, and from there (3rd row, 4th, and so on) the price that every customer offers. Starting with the best (calculated in percentage from my price).
So basically I have my price with my name of the product, and I need to see which one of my clients has the best price on offer.
It would be great if I can just input the clients list somewhere (on a different sheet) and it will give me the updates result in the first sheet. This is because every month (sometimes twice a month) prices may change.
I know it is pretty darn complicated but I even tried paying for this and didn't manage to find the answer...
Thank you in advance for any possible solution