Helping to fetch data from a sheet to a list view

[Fahim Al Mamun]

Hi All , Thanks in advance for help, I have to make an excel file automate where I have an report sheet name "test" which I have been attached, in here there have an column Q, where its showing my
packing total , Its mean if I have 48 size 2 part like A & B it will generate and automate Import Data in sheet "Import Data" for 4 time, if it have pack total 2, It will show this size Qty 2 time in import data sheet, if it pack total 8 time it will show the size total 8 row in import data sheet, and it will continue for the last stage, how to do that, please help on it.

[JeteMc]

As to the size and qty for each box:
1. Populate column AN on the test sheet using: =IF(ISODD(ROW()),"",SUMPRODUCT(--(ISEVEN(ROW()))*(Q$12:Q12)))
Note that the above-mentioned column may be moved and/or hidden for aesthetic purposes.
2. For box no.: Type 1 in the cell then right click the mouse on the fill handle and pull down and up.
3. Select series > columns > type 78 (the highest value in column AN on the test sheet) into Stop Value
4. Populate the Size column using: =INDEX(test!S$11:Y$11,MATCH(K2,INDEX(test!S$12:Y$43,AGGREGATE(15,6,(ROW(test!AA$12:AA$43)-ROW(test!AA$11))/(test!AN$12:AN$43>=I2)/(test!AN$12:AN$43<>""),1),)))
5. Populate the Qty column using: =INDEX(test!AA$12:AA$43,AGGREGATE(15,6,(ROW(test!AA$12:AA$43)-ROW(test!AA$11))/(test!AN$12:AN$43>=I2)/(test!AN$12:AN$43<>""),1))
Let us know if you have any questions.

[Fahim Al Mamun]

Thank you very much , it solved my problem, sorry for late

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.