My name is Emile and I need some help with a problem I have with a stock report.
I receive a stock report every week from a customer, I would like to make an overview on a weekly basis of the stock changes.
It's a list of more than 100 products every week. I tried to do a If function, vlookup and Index but it either doesn't work or it's not what I'm looking for.
If someone could help me and check out the attached file, the problem will become much clearer to you and might help me out with this obstacle.
I really appreciate the help
Many Thanks!!
I receive a stock report every week from a customer, I would like to make an overview on a weekly basis of the stock changes.
It's a list of more than 100 products every week. I tried to do a If function, vlookup and Index but it either doesn't work or it's not what I'm looking for.
If someone could help me and check out the attached file, the problem will become much clearer to you and might help me out with this obstacle.
I really appreciate the help
Many Thanks!!
