I'm updating a workbook someone else created a couple years ago and there are two incidences of worksheets that are identical except that Sheet 1 has the Item, Description and pricing info and Sheet 2 has Item and Description but links back to the first one for pricing info. The main sheet links back to sheet 2 to get the pricing that is in sheet 1. I need to simplify this by rerouting all internal links to the sheet with the actual information rather than the one that links to the sheet with the information. Is there an easy and graceful easy to reroute these links or do I have to do it manually? With 450+ corrections to make I'd love an easy solution lol.
Thanks Much!
Bill
Thanks Much!
Bill
