I have a column containing drop down lists with about ten options, the same drop down list appears every 4 cells, starting with B2 and is repeated hundreds of times in sheet("RunOutDates"). For each option in the drop down list I have a corresponding range of cells containing formulas on a separate sheet("Formulas"). I want to be able to make the drop down selection and have the correct range of formulas be copied and pasted from the "Formulas" tab to the "RunOutDates" tab, with the range starting two cells to the right of the drop down list.
Please help and thanks in advanced
Bookmarks