VBA to copy and paste

Hey all, let me say thanks in advance.

So, Col A B and C will be pasted in from another report. What I would like to happen is the code would look at Col C and if that value is found in Col I which will include every location at the facility, then Col A & B would be copied and pasted into the appropriate location. The appropriate location is of course the matching text value.

Problem #1 is that sometimes there will be 2 or more trailers in one location systemically. Problem #2 is that some locations have multiple slots available. For example, the locations UL10 through UL50 are more sections than they are locations because the have multiple locations available within them. So for those entries in Col C that have the UL prefix, they would just need to paste as the code encounters them.

Make sense....? I hope so. Let me know if something more is needed. Thanks.

The attachment has failed attempts to acheive the desired results using Vlookup, Match & pivot table....

If there needs to be more information, then please let me know.

Sorry. I'll try to better explain. See the new attachment and look at sheet3. I've included the desired results and more detailed notes. Please let me know if more is needed.

Zero views... You folks usually kick butt. Please let me know if I need to be more specific or define something better or anything. Let me help you, help me.

Which aspect of my explanation is causing confusion? The pasted report goes into Col A B & C. From there I need it to "filter" over to the "desired results" section (Col E throu H) based on matching locations. Col I hosts a master list of locations. The areas that are causing me the issues are this; #1 multiple trailers can be assigned to any one location, so I need to accomodate these instances. #2 The locations with the UL prefix are sections that house multiple locations with these sections. So with the other locations without the UL prefix, I would need the SCAC and Trailer# to "filter" into the row, whereas with the UL locations, the preferred result would be to have the SCAC and trailer# simply work its way down the Columns. Did that help?

Any takers? Please help. You guru's have helped me so many times. I have faith.

arlu1201, can you offer anything else?

thank you!

Col I contains all physical locations we have at the facility. The info in Col A, B & C are pasted in from another report. Col C contains the location of the trailer systemically. If Col C says that there is a trailer in location 602, then I'd like that scac and trailer number to appear next to Col I's 602.

Does that help you?

arlu1201, did you give up on me? Could you ask another experience forum member to take a look, please?

Any takers out there?

Thank you!

If the UL locations are too much of a hassle, then remove them from the master list. I can find a work around for those areas if needed.

I'm going to give it a try and I'll will let you know. Not that I doubt you, of course, but I'd like to be sure. Looking at what you posted, I am impressed. Thank you.

Worked like a dream. Thank you for saving the day.