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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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?