Excel 2007 - Need a way to find a customer quickly
Posted on 2010-11-11
Hello future point winner!
I have a workbook that has about 50 tabs or so. Each tab represents a customer sheet, and each sheet has customer ID, name, etc. I am needing a way to quickly find Customer John Smith without having to scroll through the tabs or right clicking on the scrolling arrow (which pops up a list).
Is there a way I can find a customer or a value (like the name or ID) within the sheet through a code, formula or some shortcut I don't know about? If so, could you provide or show me the way?