Hello all! I'm really hoping you can help me?!
I'm trying to create a front page for a workbook with a built in search function. I basically want the user to be able to search multiple sheets of the same workbook in cells (C5:F5) and once located, the relevant page will open, so in other words they search a customer name and once they hit return the customer sheet will open? I don't know much about Excel and I don't know if this is something that can be done using a formula or if I need to write a macro?
Also, I'd like the search page to always open when the workbook opens?
Many Thanks in advance from a befuddled secretary
Laura x
I'm trying to create a front page for a workbook with a built in search function. I basically want the user to be able to search multiple sheets of the same workbook in cells (C5:F5) and once located, the relevant page will open, so in other words they search a customer name and once they hit return the customer sheet will open? I don't know much about Excel and I don't know if this is something that can be done using a formula or if I need to write a macro?
Also, I'd like the search page to always open when the workbook opens?
Many Thanks in advance from a befuddled secretary
Laura x