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. Data.xlsx
Apologies but my code above would pick out 15 if 5 were entered as it was looking at any part of the cell in the find method. Its corrected below.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …