Looking for a vba code to search for the value in sheet 3 A1, in sheet 1 BE2 to BW 6. When found, then search for criteria in Sheet 3 K2:T2 in Sheet 1 BD3:BW 23. When both criteria are found copy and paste the data into sheet 3 K3. I have attached an example of what the data is suppose to look like. The valube in sheet 3 A1, is not constant it will change upon certain conditions.