I have a spreadsheet that contains supplier lists, destinations, rates, segments, and codes (segments & codes are the same thing). I need to align the segments and codes that match. IF the code & segment match then they need to align with the cost, supplier for that destination, (which is A,B,C). IF the Segment doesn't match the code, then move it to the right of the column or the end. I have tried everything! Not sure if there is a formula or need a vb script? Please help!!
Last edited by amy2014; 07-24-2014 at 08:54 AM.
If you post a sample workbook it will be much easier to help you.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
I have a spreadsheet that contains supplier lists, destinations, rates, segments, and codes (segments & codes are the same thing). I need to align the segments and codes that match. IF the code & segment match then they need to align with the cost, supplier for that destination, (which is A,B,C). IF the Segment doesn't match the code, then move it to the right of the column or the end. I have tried everything! Not sure if there is a formula or need a vb script? Please help!!
I have attached a sample file.
Last edited by amy2014; 07-23-2014 at 09:21 AM.
Hello Jacc, I appreciate you looking into this for me
This will be very hard to do since the names are in different order in the different columns. Maybe a Fuzzy lookup would do it. Another option would be to split up the content of the cells in multiple cells.
I'm a bit short on time right now and even if I had the time I doubt that I could solve it.
Hi Jacc, I'm sorry forgot to point that out. The destination names are not exactly the same which is not a problem, we could get rid of destination2 and keep Column 'C' for name. the key is the codes and segments to match along with cost and supplier. Some customers use the destination name slightly different, but as long as codes & segments match that's whats important. Does that make it easier or should I try CS?
Thread posted in CS forum hence closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks