match columns and insert cell for mismatch

May 29, 2012 at 04:48:53
Specs: Windows XP
Dear Sir,
I need your help for the following.
I have below sample sheet and the ROWS are as many as 50,000 here is the EXAMPLE for some ROWS.
A B C D E F G H I
Source Category Name Debit Source Category Name Credit
XYZ XYZ XYZ 15 XYZ XYZ XYZ 20
XYZ XYZ XYZ 20 XYZ XYZ XYZ 34
XYZ XYZ XYZ 20 XYZ XYZ XYZ 35
XYZ XYZ XYZ 34 XYZ XYZ XYZ 35
XYZ XYZ XYZ 35 XYZ XYZ XYZ 36
XYZ XYZ XYZ 35 XYZ XYZ XYZ 40
XYZ XYZ XYZ 36 XYZ XYZ XYZ 45
XYZ XYZ XYZ 40 XYZ XYZ XYZ 48
XYZ XYZ XYZ 45 XYZ XYZ XYZ 72
XYZ XYZ XYZ 48
XYZ XYZ XYZ 50

I want to match the debit and credit and if not match it should be blank as follows.
A B C D E F G H I
Source Category Name Debit Source Category Name Credit
XYZ XYZ XYZ 15
XYZ XYZ XYZ 20 XYZ XYZ XYZ 20
XYZ XYZ XYZ 20
XYZ XYZ XYZ 34 XYZ XYZ XYZ 34
XYZ XYZ XYZ 35 XYZ XYZ XYZ 35
XYZ XYZ XYZ 35 XYZ XYZ XYZ 35
XYZ XYZ XYZ 36 XYZ XYZ XYZ 36
XYZ XYZ XYZ 40 XYZ XYZ XYZ 40
XYZ XYZ XYZ 45 XYZ XYZ XYZ 45
XYZ XYZ XYZ 48 XYZ XYZ XYZ 48
XYZ XYZ XYZ 50
XYZ XYZ XYZ 72

I hope you understand the above as my english is not good. I will be appreicate if you pleae provide me the marco. Please note the ROWS will be as many as.
Thanks,


See More: match columns and insert cell for mismatch

Report •


#1
May 29, 2012 at 05:01:22
Sir I am first Time visitor here, and I have seen you are genious...

Report •

#2
May 29, 2012 at 08:15:03
Please click on the blue line at the end of this post and read the instructions on how to post example data in this forum.

Then repost your sample data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
May 30, 2012 at 01:00:04
A B C D E F G H
XYZ XYZ XYZ 15 XYZ XYZ XYZ 20
XYZ XYZ XYZ 20 XYZ XYZ XYZ 34
XYZ XYZ XYZ 20 XYZ XYZ XYZ 35
XYZ XYZ XYZ 34 XYZ XYZ XYZ 35
XYZ XYZ XYZ 35 XYZ XYZ XYZ 36
XYZ XYZ XYZ 35 XYZ XYZ XYZ 40
XYZ XYZ XYZ 36 XYZ XYZ XYZ 45
XYZ XYZ XYZ 40 XYZ XYZ XYZ 48
XYZ XYZ XYZ 45 XYZ XYZ XYZ 72
XYZ XYZ XYZ 48
XYZ XYZ XYZ 50

I want to match the debit and credit and if not match it should be blank as follows.
A B C D E F G H
XYZ XYZ XYZ 15
XYZ XYZ XYZ 20 XYZ XYZ XYZ 20
XYZ XYZ XYZ 20
XYZ XYZ XYZ 34 XYZ XYZ XYZ 34
XYZ XYZ XYZ 35 XYZ XYZ XYZ 35
XYZ XYZ XYZ 35 XYZ XYZ XYZ 35
XYZ XYZ XYZ 36 XYZ XYZ XYZ 36
XYZ XYZ XYZ 40 XYZ XYZ XYZ 40
XYZ XYZ XYZ 45 XYZ XYZ XYZ 45
XYZ XYZ XYZ 48 XYZ XYZ XYZ 48
XYZ XYZ XYZ 50
XYZ XYZ XYZ 72

Sir, I have tried the above but space doesnot showing in preview changes it is not working with me.

Please See the example for 1st row
A B C D E F G H
XYZ XYZ XYZ 15 XYZ XYZ XYZ 20

Row is like this Under A ( XYZ ) Under B ( XYZ ) and Under C ( XYZ ) and D ( 15 ) this is part one for debits and the part two is start from E ( XYZ ) F ( XYZ ) G ( XYZ ) and H ( 20 )

I hope you understand the above. if you can please advise how can I attached the file and send it to you .
Thanks,


Report •

Related Solutions

#4
May 30, 2012 at 12:45:02
It's really not that hard to use the pre tags to format your data. The instructions are found via the link at the bottom of this post.

   A      B       C    D     E       F      G     H
Source Category Name Debit Source Category Name Credit
  XYZ    XYZ     XYZ   15   XYZ     XYZ    XYZ   20
  XYZ    XYZ     XYZ   20   XYZ     XYZ    XYZ   34

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#5
May 31, 2012 at 16:08:23
A B C D E F G H
XYZ XYZ XYZ 15 XYZ XYZ XYZ 20
XYZ XYZ XYZ 20 XYZ XYZ XYZ 34
XYZ XYZ XYZ 20 XYZ XYZ XYZ 35
XYZ XYZ XYZ 34 XYZ XYZ XYZ 35
XYZ XYZ XYZ 35 XYZ XYZ XYZ 36
XYZ XYZ XYZ 35 XYZ XYZ XYZ 40
XYZ XYZ XYZ 36 XYZ XYZ XYZ 45
XYZ XYZ XYZ 40 XYZ XYZ XYZ 48
XYZ XYZ XYZ 45 XYZ XYZ XYZ 72
XYZ XYZ XYZ 48
XYZ XYZ XYZ 50

I want to match the debit and credit and if not match it should be blank as follows.
A B C D E F G H
XYZ XYZ XYZ 15
XYZ XYZ XYZ 20 XYZ XYZ XYZ 20
XYZ XYZ XYZ 20
XYZ XYZ XYZ 34 XYZ XYZ XYZ 34
XYZ XYZ XYZ 35 XYZ XYZ XYZ 35
XYZ XYZ XYZ 35 XYZ XYZ XYZ 35
XYZ XYZ XYZ 36 XYZ XYZ XYZ 36
XYZ XYZ XYZ 40 XYZ XYZ XYZ 40
XYZ XYZ XYZ 45 XYZ XYZ XYZ 45
XYZ XYZ XYZ 48 XYZ XYZ XYZ 48
XYZ XYZ XYZ 50
XYZ XYZ XYZ 72

Sir I arranged again in the message box but when i go to preview again it showing near to each other, If you please help me I think you understand A to H are columns and bottom lines XYZ are rows and the numbers in column D are debit values and the numbers in H are credit values what I need is if gave the example above, I hope and I am sure you will defenately have the solution for this. Please note the number of rows what I have is around 50 thousand. Thanks,


Report •

#6
May 31, 2012 at 16:58:06
A B C D E F G H
1 XYZ XYZ XYZ 15 XYZ XYZ XYZ 20
2 XYZ XYZ XYZ 20 XYZ XYZ XYZ 34
3 XYZ XYZ XYZ 20 XYZ XYZ XYZ 35
4 XYZ XYZ XYZ 34 XYZ XYZ XYZ 35
5 XYZ XYZ XYZ 35 XYZ XYZ XYZ 36
6 XYZ XYZ XYZ 35 XYZ XYZ XYZ 40
7 XYZ XYZ XYZ 36 XYZ XYZ XYZ 45
8 XYZ XYZ XYZ 40 XYZ XYZ XYZ 48
9 XYZ XYZ XYZ 45 XYZ XYZ XYZ 72
10 XYZ XYZ XYZ 48
11 XYZ XYZ XYZ 50
I want to match the debit and credit and if not match it should be blank as follows.
A B C D E F G H
1 XYZ XYZ XYZ 15
2 XYZ XYZ XYZ 20 XYZ XYZ XYZ 20
3 XYZ XYZ XYZ 20
4 XYZ XYZ XYZ 34 XYZ XYZ XYZ 34
5 XYZ XYZ XYZ 35 XYZ XYZ XYZ 35
6 XYZ XYZ XYZ 35 XYZ XYZ XYZ 35
7 XYZ XYZ XYZ 36 XYZ XYZ XYZ 36
8 XYZ XYZ XYZ 40 XYZ XYZ XYZ 40
9 XYZ XYZ XYZ 45 XYZ XYZ XYZ 45
10 XYZ XYZ XYZ 48 XYZ XYZ XYZ 48
11 XYZ XYZ XYZ 50
12 XYZ XYZ XYZ 72



Report •

#7
May 31, 2012 at 17:01:03
Sir, If you copy and paste the above date in message box it look OK.
Thanks,
Waiting for your response.

Report •

Ask Question