Form look up

**JOONA** · 12-03-2013, 08:35 AM

I HAVE A SPREAD SHEET THAT WE USE AT WORK CALLED CHECK SHEET IT ALLOWS US TO SEE WHAT ENGINEERS ARE IN AND IF NO WHO IS COVERING ETC. I HAVE INDIVIDUAL SHEETS SET UP FOR EACH BRANCH FOR EXAMPLE

ABERDEEN GLASGOW EDINGBURGH ETC.

What I want to know how to do is on a blank sheet have a form that allow me to search through all of the sheets and give me information depending on what I type in

The sheets are layout like so

Branch, Engineer Comments Covering Engineer and Telephone number.

When I type wither engineer number in it should then search all the sheets to find the matching number and then return/load up that sheet and high light the cells nxt to it so that I can see who is covering etc is this possible if so could I please have instructions on how to do this as there is 23 separate branches with there own sheets and they are all se up the same.

Bristol 201F21000 Southwest Region

Engineer Comments Covering engineer Mobile numbers not or incorrect on JDE

I have know knowlede of vba so step by step inSTRUCTIONS WOULD BE USEFULL

**AndyLitch** · 12-03-2013, 08:40 AM

Can you upload an example

What you need is basically :-
1. A database of Engineers
2. An Areas database
3. A schedule of who's covering each day
4. A means of manually assigning Engineers to fill in the gaps...

Easy peasy

**TMS** · 12-03-2013, 08:44 AM

You will, undoubtedly, be asked by a Moderator to change your thread title in order to comply with forum rules.

In the meantime, you might want to consider an alternative approach.

Instead of having separate sheets for each Branch, have one sheet with all the data for all the Branches and all the engineers. All you need to do is add a column with the Branch name or code at the beginning.

Then you won't need a form, or VBA, which must be a plus given that you don't know VBA. You will simply be able to use Sort and/or Autofilter to look at Branch and engineer data.

Regards, TMS