RandomUserCode
New Member
- Joined
- Aug 4, 2021
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi, im new to VBA and i want to access a path on my Windows computer. Tha path contains the master workbook and two workbooks with information in sheet 1 (in both of them).
The two data workbooks contains 3 columns with an id in the first column, date in the second and nominal ind the third.
I want to copy data from sheet 1 in the first data workbook and copy data from sheet 1 in the Second data workbooks. All this needs to be pasted into my master workbook. Then i would like to compare the two data sets in sheet 1 of my master workbook. So first check if the id is the same, then check if the date is the same, and at last check if the nominal is the same. The differences need to be shown in sheet 2 column A, the next data input in sheet 2 column B and so on
hope someone can help me out, i know it’s a looot to do. TIA
The two data workbooks contains 3 columns with an id in the first column, date in the second and nominal ind the third.
I want to copy data from sheet 1 in the first data workbook and copy data from sheet 1 in the Second data workbooks. All this needs to be pasted into my master workbook. Then i would like to compare the two data sets in sheet 1 of my master workbook. So first check if the id is the same, then check if the date is the same, and at last check if the nominal is the same. The differences need to be shown in sheet 2 column A, the next data input in sheet 2 column B and so on
hope someone can help me out, i know it’s a looot to do. TIA
