I have a row of values that represent annual production from a certain mining area. I want to take those values and shuffle them within a broader combined schedule by creating a user configurable offset that moves the entire series of values to a new start date.

Any idea on what would be the easiest way to do this??

settle everyone… I think I have it sorted…

I’d probably do it with a bit of VBA using the offset function, but I’m not exactly clear what you want to do at the moment.

Automatic copying of data to a different range is straightforward, but do you need to insert it into existing data?

diddly-squat said:

settle everyone… I think I have it sorted…

So how did you do it?

The Rev Dodgson said:

diddly-squat said:

settle everyone… I think I have it sorted…

So how did you do it?

worked it out with a pencil…

diddly-squat said:

settle everyone… I think I have it sorted…

That’s good. I didn’t understand the question.