Excel Help

rctneil · 12 Sep 2009 at 12:43

Hello,
There are two things I would like help with doing in Excel.

1.) How can I add a button to a spreadsheet that will jump to a different sheet?

2.) I ahve 3 sheets where I want to search for a text string. Currently to do this I have to press Control-F and then change the options to say search in every sheet and then search for what I want to find. Can I have a text field at the top of each sheet where I can type what I wnat and press a "Find" button and it do it's normal search but automatically search over all the sheets in the document?

Thanks

Regards,
Neil

rctneil · 12 Sep 2009 at 12:47

This document is for my own personal and sole use.

I would need tutorials on how to do these though

rctneil · 12 Sep 2009 at 12:51

That would be great Geuben. I'll wait for a bit too see what other people come up with but some step by steps would be most appreciated.

Thanks

rctneil · 12 Sep 2009 at 12:52

I am using 2010 beta but It's similar to 2007.