Hi there,

So I have a workbook with a data validated list which forms a toggle, changing calculations throughout the workbook.

I need to create a code that cycles through the values of the list, whilst copying the results of each change to a table in a new sheet.

The list is a named range, "BC", and the cell with the data validated list is named "BCToggle". All of the ranges which I wish to copy are named "Copy....."
("CopyBC" and "CopyDate" for example)

All the copy ranges are (1,27) in size, as they are values over a 27 month period. The output table needs to have a column per each copy range, with the newly copied values appended below following each step through the list, thus creating a flat table.

My current code is:

Sub BCCycle()
Dim counter As Long

counter = 1
For Each cell In Range("BC").Cells(counter, 1)
Range("BCToggle") = cell.Value
Call DataRip
counter = counter + 1
Next

End Sub

But I am unsure of how to cycle through each copy range, pasting each into a new column, and also of how to ensure the new values are appended to the table rather than overwriting what is already there.

Many thanks!