GrahamTerry
New Member
- Joined
- Mar 11, 2009
- Messages
- 1
Help !!!
I am collating prices over 4 or more worksheets and have calculations within the individual worksheets to arrive at various totals (prices of container movements from various Chinese ports to various UK towns).
I now need to compare these totals across the (currently) 4 worksheets on a 5th sheet so that the cheapest price is shown in a particular box on that 5th sheet preferably with a hyperlink to the cheapest cell built in!!!
A foreseen problem will be that in my 'total' cells I have a formula and I need to compare the content of the cell not the formula!
Am I asking too much of Excel or is it a problem I need to address with Visual Basic?
Thanks for any assistance.
Graham
I am collating prices over 4 or more worksheets and have calculations within the individual worksheets to arrive at various totals (prices of container movements from various Chinese ports to various UK towns).
I now need to compare these totals across the (currently) 4 worksheets on a 5th sheet so that the cheapest price is shown in a particular box on that 5th sheet preferably with a hyperlink to the cheapest cell built in!!!
A foreseen problem will be that in my 'total' cells I have a formula and I need to compare the content of the cell not the formula!
Am I asking too much of Excel or is it a problem I need to address with Visual Basic?
Thanks for any assistance.
Graham