oliverways
New Member
- Joined
- Aug 19, 2011
- Messages
- 1
I was wondering if there's anyone to help me out to write a macro to compare two lists on two different sheets, on sheet1 there's the incomplete list but with ordered data and on sheet2 is the complete list with static data(they are always like this and do never change), so what i wanna do is to add an empty row on sheet1 in the corrispondence of missing data.
my initial situation would be like this:
list1 list2
1 1
2 2
3 3
4 4
7 5
8 6
9 7
8
9
10
and i want to obtain the following result by modifying (inserting new empty row) list1 on sheet1:
list1 list2
1 1
2 2
3 3
4 4
5
6
7 7
8 8
9 9
10
i'd appreciate very much if some one could help me, thanks in advance to everyone! i'm new on this macro's world!
my initial situation would be like this:
list1 list2
1 1
2 2
3 3
4 4
7 5
8 6
9 7
8
9
10
and i want to obtain the following result by modifying (inserting new empty row) list1 on sheet1:
list1 list2
1 1
2 2
3 3
4 4
5
6
7 7
8 8
9 9
10
i'd appreciate very much if some one could help me, thanks in advance to everyone! i'm new on this macro's world!
Last edited: