Hi XL lords,
I have a large spreadsheet with a series of tabs. The tabs represent various rival companies. Within each tab (1 company), each row represents one day of price information, with each column being a different product type. What I want to do is create a summary tab somewhere which automatically detects any changes in price of any product of any competitor and then captures that information.
Please see attached for an idea of what I'm going on about.
Ideally, the summary would only show products where there has been a change in price. Because I am dealing with 1000s of products, it would not be much of a summary if there were 950 products which just had a blank for the price change. Although, I could probably just apply a filter to get rid of any rows where there was a 0 change.
Not sure if this is doable without VBA.
Let me know any thoughts you have; they would be very much appreciated!
Bookmarks