Hello All! I have a list of data and I want to pull it into another sheet in the workbook but I want to pull in the first value in the list so say from A1 from the other sheet into cell A1 in the sheet with the formula and then duplicate that value for 17 cells under it, then have 1 blank cell and then in cell A20 pull the next value in the list from the other sheet in cell A2. Any help would be much appreciated!