'Pasting a named dynamic variable range (what a mouthfull!!)

[Adam Kelly]

Note: I have already asked this question, and below is my reply to a suggested solution which I'm afraid was unsuccessful - I'm hoping someone will recognise my problem........


The range I wish to 'paste' is a dynamic moveable range (at least, thats what I think its called!!) - so the range varies in both size and position - though the data is always in column B in 'sheet 1'

I probably havent explained that too well.......
My range ("after_times") varies from (for example) B7:B16 to B12:B44

as far as I can see, my range is working, i.e. picking up the correct data from the correct place, and varying in size and location in accordance with the data added in column B meeting my pre-determined criteria

What I want to do is 'paste' (if that is the correct term) the data in the range to column B on a second sheet - with the first of the data being in B2

so.......for example

If my 'after_times' range is B7:B16(1 column x 10 rows) on sheet 1, I want the same data in sheet 2 B2:B11 (1 column x 10 rows), and when the range 'moves' on sheet 1 to B12:B44 (1 column x 33 rows), I want sheet 2 to show the same data in B2:B34 (1 column x 33 rows)

any further suggestions?

anybody?!!

 

[GlennUK]

Can't you just INDEX into it? You'd need to test whether you're past the end of the data, and you'd need to populate formulas up to the maximum size of 'after_times' ... like:

=IF((ROW()-1)>ROWS(after_times),"",INDEX(after_times,ROW()-1))

in cell B2 copied down.