LinkBack URL
About LinkBacks
I need to match the attached data so code 1 along with its data matches code 2. The excel sheet is attached. I do not not know how to do this.
All help is greatly appreciated, I have been stuck on this problem for a couple of weeks now.
I need to match the attached data so code 1 along with its data matches code 2. The excel sheet is attached. I do not not know how to do this.
All help is greatly appreciated, I have been stuck on this problem for a couple of weeks now.
Not sure what is your expected result and which is your source data
Please give some brief about your data for my better understanding
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I thought the expected result is trivial, but Ill explain anyway. I need code1 to match code2 without losing its attachment to code0.
Sorry, I dont understand what you want either
What is code 1's data? Keep in mind, this is blatantly obvious to you, but we really have no idea what you are working withI need to match the attached data so code 1 along with its data matches code 2.
Perhaps you samples of what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If you move col B one column left, there's a worbook at https://app.box.com/shared/elrnbidnr7 that will do this:
Row\Col 0000001391689 HST 0000004655215 HST 0000004655215 0000007745443 HST 0000007745443 0012511446529 NT 0018787772324 HST 0018787781050 HST 0018787783054 HST 0018787784051 HST 0018787785058 HST 0018787786055 HST 0018787787052 HST 0018787788059 HST 0024182000207 NT 0024182002126 NT 0024182002188 NT 0024182003505 NT 0024182003512 NT 0024182003529 NT 0024182003536 NT 0024182003543 HST 0024182003550 NT 0024182003567 NT 0024182003581 NT 0024182003598 NT 0024182003604 NT 0024182003628 NT 0024182003864 NT 0024182013160 NT 0024182023527 NT 0024182023565 NT 0024182031515 NT 0024182031522 NT 0024182151695 NT 0024182300130 NT 0024182425901 NT 0024182493153 NT 0026395000043 HST 0026395000128 HST 0032917101815 NT 0032917101853 HST 0032917101877 NT 0033674105009 HST 0033674105009 0033674112007 HST 0033674135006 HST … …
Entia non sunt multiplicanda sine necessitate
This is exactly what I need, I'm having trouble using the workbook though. I moved code 2 to column A and defined it as a keys, when I press Alt f8 and run AlignKeys, I get error "All cells of named range "keys" must be in the same row."Originally Posted by shg
In the example I posted, I selected A1 and C1, and entered Keys in the Names box (left of the formula bar). Then I ran the macro.
I ran the macro, but the problem still persists as the macro does not match items with leading zero's. For example: I have 063151250199 & 0063151250199 these are considered as the same, so I need them matched.
But they aren't the same. Numbers with leading zeros are strings, and strings are compared character by character. If leading zeros are not significant, convert them to numbers, so they disappear.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks