Issues selecting the correct range of data and inserting it in another tab via a range

So first of all I trully appreciate all of your assistance to everyone you all are amazing.
Here is my big dilema today.

In the second tab I can enter 2 values minimum and maximum for example D36310 & D36366 (Fyi: theses are Rack numbers with Shelf) so I can also state that each Rack for this series have 4, 5 or 6 Shelfs per rack. So Each Rack if I enter 4 ( as the number of shelf for this serie) will generate in another tab a series of values ( this is working great already aleluya lol) . Example: D36310 A ; D36310 B ;D36310 C; D36310 D ; D36312A; etc.. ( So each Shelf will have the same Rack# and will add the Rack ID value A,B,C,D ( for a 4 shelf rack).
I hope that I have not confuse you too much by now. So in this example we know that the absolute amount of ROW in excel should be 224 Row Starting from Row D36310 A to D36366 D ( FYI: it is always either odd or even number that are accumulating)


So now my full range as been created, up to here it s working.
Where the dilema got me staling now is how can I find a specific range of number from tab 3 between D36310 A to D36366 D and automaticaly enter that into tab1.

And then it will get more confusing also later on, because i need each tab as they are getting enter, to accumulate on tab 1 without overwriting the previous row but accumulating the data.

To make it easier hopefully here is a specific breakdown and how the sequence is happening.

The driving cell will be ( Template Rack data Tab) / Rack#: Start D36 310 and End D36 366 .
Once this data is being entered I will tell how many shelves are on this Rack alley, for example 4 ( Cell N2).
Then Tab 3 will automatically already now compute all the Rack ID ( Working Copy tab) , theses will be all of the possibilities of Rack # with ID.

So knowing that I entered a 4 for the 4 shelves on Cell N2, I need to have the (Section tab) Starting at cell F4 to copy the range created on the ( Working copy tab, but only for the . I2 to I117 Being D36310 D.


Once this work I would like to make about 30 copies of this ( Template Rack & Working copy Tab attached to each) rename it, and be able to enter all the data on each Template Rack Tab in this workbook, and all of the data will accumulate in the Section Tab.

I hope that I have not give you a serious headache by now.

Thank you for all of your help and support as always.

Alex

Please take a few minutes to re-read the forum rules, and then amend your thread title accordingly.

Thanks.

Okay, here come the questions.
On Template Rack data!, you enter values in H5, J5, H7, J7 and N2 based on your knowledge of the racks. This information (particularly N2) is not contained anywhere in your workbook. Correct?

This data is then used to create a range of data on Working Copy! using formulas. Correct? We can come up with better formulas so you'll just create what you need and not need all those extra rows and columns.

Then you want the data from Working Copy! to be transferred into SECTION! Why didn't you just have it generated in SECTION in the first place? Which columns in SECTION! do you expect to be populated from Working Copy!?

We'll start there.

Okay, as a first step, I've added the appropriate formulas to create all your shelves in "Working Copy!".
First I started on row 15 because in Column C, I use an offset which could be as much as 12 to see if we've reached our limit. So I kept rows 1-14 blank to be on the safe side.

B16, C16 and B15 are pulled direct from Template Rack Data!
In B17 copied down
=IF(ISNUMBER(C17),B16,"")

In C17 copied down
=IF(OR(C15="",OFFSET(C16, -$B$15+1,0)='Template Rack data'!$J$7),"", $C$16+2*(INT((ROWS($C$16:$C17)-1)/$B$15)))

In D16 copied down
=IF(ISNUMBER(C16),CONCATENATE(B16,C16),"")

In E16 copied down
=IF(ISNUMBER(C16),CHAR(MOD(ROWS($E$16:$E16)-1,$B$15)+65),"")
This formula creates the character using the ASCII code value (65 for A, 66 for B, 67 for C and so forth).

Questions?