I need some help.
I have strings of numbers separated by periods (e.g. 1.3.6.1.2.1.1.1.2.0) in column A of two different worksheets in the same work book. I need to compare wb1$a1 to wb2$a1 and if <> insert a row (pushing data down) in the row where a1 is the higher value.
The net result would be to have two worksheets where data is aligned (i.e. same row in both worksheets have the same value in column a).
So, wb1 has
row#
1 1.3.6.1.2.1.1.1.2.0
2 1.3.6.1.2.1.1.1.2.1
3 1.3.6.1.2.1.1.1.2.2
4 1.3.6.1.2.1.1.1.2.4
5 1.3.6.1.2.1.1.1.2.6
6 1.3.6.1.2.1.1.1.2.8
wb2 has
row#
1 1.3.6.1.2.1.1.1.2.0
2 1.3.6.1.2.1.1.1.2.1
3 1.3.6.1.2.1.1.1.2.2
4 1.3.6.1.2.1.1.1.2.3
5 1.3.6.1.2.1.1.1.2.5
6 1.3.6.1.2.1.1.1.2.7
7 1.3.6.1.2.1.1.1.2.8
After the macro runs I want to see
wb1
row#
1 1.3.6.1.2.1.1.1.2.0
2 1.3.6.1.2.1.1.1.2.1
3 1.3.6.1.2.1.1.1.2.2
4
5 1.3.6.1.2.1.1.1.2.4
6
7 1.3.6.1.2.1.1.1.2.6
8
9 1.3.6.1.2.1.1.1.2.8
and wb2
row#
1 1.3.6.1.2.1.1.1.2.0
2 1.3.6.1.2.1.1.1.2.1
3 1.3.6.1.2.1.1.1.2.2
4 1.3.6.1.2.1.1.1.2.3
5
6 1.3.6.1.2.1.1.1.2.5
7
8 1.3.6.1.2.1.1.1.2.7
9 1.3.6.1.2.1.1.1.2.8
Thanks,
Bookmarks