Invader126
New member
- Joined
- Dec 30, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
hi,
new to this site. dont have a lot of experience with VBA.
i need a vba code to do the following
Values in column A and C, Digits in column B and D
the Macro needs to compare the data of column A and B against column C and D and cut / move the duplicate data to Sheet2. it needs to be in the exact same format as sheet 1. value, digits, value, digits.
at the end i should be left with all entries in columns A of entries that did not match and in sheet 2 all the entries that did match. it should only match one entry in the columns. if there are two matches in the first line and only one in the second, then only one should be moved.
example:
Sheet 1 before start
Column A Column B Column C Column D
20 10 10 20
10 7 17 10
10 20 8 7
10 7 10 7
then afterwards:
Sheet 1:
Column A Column B Column C Column D
20 10 17 10
10 7 8 7
Sheet 2:
Column A Column B Column C Column D
10 7 10 20
10 20 10 7
any help would be appreciated.
thank you
new to this site. dont have a lot of experience with VBA.
i need a vba code to do the following
Values in column A and C, Digits in column B and D
the Macro needs to compare the data of column A and B against column C and D and cut / move the duplicate data to Sheet2. it needs to be in the exact same format as sheet 1. value, digits, value, digits.
at the end i should be left with all entries in columns A of entries that did not match and in sheet 2 all the entries that did match. it should only match one entry in the columns. if there are two matches in the first line and only one in the second, then only one should be moved.
example:
Sheet 1 before start
Column A Column B Column C Column D
20 10 10 20
10 7 17 10
10 20 8 7
10 7 10 7
then afterwards:
Sheet 1:
Column A Column B Column C Column D
20 10 17 10
10 7 8 7
Sheet 2:
Column A Column B Column C Column D
10 7 10 20
10 20 10 7
any help would be appreciated.
thank you