Excel word Formula

[pob5132]

I am currently trying to create a spread sheet for my company that in column A is the customer name. Column B is the reason why they are at the store. My goal is when they type in either 'Sales' or 'Repair' it will take them to another sheet that will go to the department in control of the needed function.



I tried the IF formula and the OR formula and could not figure it out. Please help me out if you could help me with giving me a link to a video doing this action or a formula I can copy and paste and just change the cells I need.Thank you.

[Pecoflyer]

Hi
perhaps provide a small sample file showing what you have and expected results ( no pics please)

[pob5132]

Ok I will try and explain it out.

So column A is customer then Column B is the service they need, either sales or repair.

Once sales or repair is type into column B, I am wondering if there is a way to use that as a key word that will upload their information into either a Sales or Repair spreadsheet based on the information typed into column B.

Is that any better?

[macropod]

You can't do that with a formula - VBA programming would be required. Besides which, the details you've given us so far don't amount to much - a customer name and service type. Presumably, there'd be a bunch of other data that needs to go into the Sales or Repair workbook, but you've given us no indication of where that comes from or where it is to go.