Dear all, i'm new here and struggling with a vba issue.
I have a workbook with three sheets in it. They all are raw data (downloaded from a CRM program at my workplace). In another workbook i have a sheet called INDEX and VRD. VRD is basicly the cleaned data from the three sheets as i mentioned before. INDEX is a sheet whith calculations.
What i want is to use a vba statement to copy the data from the three sheets based on a criteria. The criteria is the cellvalue (A2:A698) of sheet INDEX. So far i came up with this code:
So to continue: LOK should be the INDEX!$A2:$A698..... from here i'm stuck. Could someone help me out?Please Login or Register to view this content.
So far thanks in advanced
Bookmarks