In a workbook I am creating Sheet 1 contains entries for each day of the year. I am looking for a way to Copy & Paste every 40th cell in a column & paste them into a column on Sheet 2 without haveing to do each one seperately. Anyone have any ideas? Thanks