Conditional Formatting to show a numbers of cells based on a lookup value

Hi guys,

Need your help with something. I have a list of movements, and I am trying to show how each of these would be handled based on the capacity of the tractor that will be positioning the items to another location.
The capacity of this item is 2 objects at a time, so depending on how many I receive it will take X runs to finish unloading the truck. The trailer type determines the total capacity i.e 53" = 22 pallets, which means this will require 11 runs to unload the truck completely.
What I want to do, is based on the equipment type, populate the rows to show how each run would happen. So if the equipment type is 53' I want to populate 11 rows in the "pallet data" tab with the MIA information (Origin and Arrival Time).
If the equipment type is 24' I want it to only populate 6 rows and so on.
I have seen this done somewhere with conditional formatting, but have not been able to find a tutorial or figure it out myself.

I've attached the file with initial data.

Please let me know if you have any ideas on how I can approach this.
Thank you!

I don't see how you could do this with conditional formatting - that just formats cells according to some criteria.

Do you want to expand each row you have by the number of rows shown in column G?


Pete

Yes, but I want the details in a different sheet. Where I can update just the origin locations and flights and the rest will populate.

In the attached file I put zero in cell H4 and this formula in H5:

=G5+H4

which when copied down just gives a cumulative count of the number of rows.

Then in a new sheet (Sheet1), where I have added your titles in row 1, I put this formula in A2:

=IF(ROWS($1:1)>MAX(Parameters!$H:$H),"",(INDEX(Parameters!B$5:B$9,MATCH(ROWS($1:1)-1,Parameters!$H$4:$H$9))))

This can be copied across, although you will need to change the formatting in B2. Then you can copy the 4 formulae down as far as you need to (until you start to get blanks).

Hope this helps.

Pete