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 and supplier for that destination, (which is A,B,C). If there is a code or segment that has no matches (which there shouldn’t be) move to end of file. I have tried everything! Not sure if there is a formula or need a vb script? Please help!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel 2011 MAC, need a vb script or formula for sorting aligning spread sheet!
- Thread starter amy2014
- Start date
XLfriend777
Well-known Member
- Joined
- Nov 15, 2013
- Messages
- 690
Hi amy2014 - Welcome to the forum. I think what would help is to see a small sample of your data. I'm having a hard time understanding what you mean bey "align" and what needs to align with what. Hope this helps get your thread started.
Upvote
0
Similar threads
- Question
