nether
01-05-2006, 07:20 AM
Hi guys,
I have surfed alot on the internet today, but i havent found a solution for my problem.
The problem is the following.
In a workbook I have 2 sheets. In the one sheet there is the stock which is in our accounting system. In the second sheet there is the stock which was counted manually from the stock room.
Now, i want to compare the two sheets. When comparing, the macro should first check if the itemnumber which exists in the "oracle" sheet also exists in the scan sheet. If it doesnt, it should write the line to a 3rd sheet which is created at that time.
if the item does exist in the scan sheet, then it should copy the quantity from the scanned item to the oracle sheet, behind the row of the same item iin the oracle sheet.
I know there are a lot of comparison code samples around, but i haven't found one which fits my needs yet. :banghead: (Im a beginner in VBA-programming, so thats why I posted this question here).
As a attachment i added a copy of a demo-sheet to this post. Can someone help me with this???
Thx
Rolf
I have surfed alot on the internet today, but i havent found a solution for my problem.
The problem is the following.
In a workbook I have 2 sheets. In the one sheet there is the stock which is in our accounting system. In the second sheet there is the stock which was counted manually from the stock room.
Now, i want to compare the two sheets. When comparing, the macro should first check if the itemnumber which exists in the "oracle" sheet also exists in the scan sheet. If it doesnt, it should write the line to a 3rd sheet which is created at that time.
if the item does exist in the scan sheet, then it should copy the quantity from the scanned item to the oracle sheet, behind the row of the same item iin the oracle sheet.
I know there are a lot of comparison code samples around, but i haven't found one which fits my needs yet. :banghead: (Im a beginner in VBA-programming, so thats why I posted this question here).
As a attachment i added a copy of a demo-sheet to this post. Can someone help me with this???
Thx
Rolf