Hello to all visitors of this post,
I'm trying to compile some data to help out myself and fellow co-workers. I'm not an expert in excel by any means but here is what I have so far.
I have multiple sheets (about 70 in all) that have data of customers that show pricing, quantity, and total costs of products. My very first sheet is a summary sheet and in that summary sheet I have 2 columns, one for MINs and one for MAXs. These return, for example, the MAX price that was charged to a customer. So it searches all my sheets and returns the highest value in say cell I2 of all the sheets.
My problem I have the value now, but who's sheet contains that value. I'd like to set up a dynamic hyperlink so when u click it it'll take you to at least one of the customers that have that value. Not sure there would be a way to show each customer that had that value. But getting to the first one would be of great help by itself.
Thanks for your time and any help,
DW
I'm trying to compile some data to help out myself and fellow co-workers. I'm not an expert in excel by any means but here is what I have so far.
I have multiple sheets (about 70 in all) that have data of customers that show pricing, quantity, and total costs of products. My very first sheet is a summary sheet and in that summary sheet I have 2 columns, one for MINs and one for MAXs. These return, for example, the MAX price that was charged to a customer. So it searches all my sheets and returns the highest value in say cell I2 of all the sheets.
My problem I have the value now, but who's sheet contains that value. I'd like to set up a dynamic hyperlink so when u click it it'll take you to at least one of the customers that have that value. Not sure there would be a way to show each customer that had that value. But getting to the first one would be of great help by itself.
Thanks for your time and any help,
DW
