Pulling Items from a multiple column Range

Good morning,
I have a sheet with Races as per the attached example.
I need to be able to pull the information into another section of the workbook and place it into order (ie Black 1,2,3,4) and then drop down to the next row and place Blue 1,2,3,4 etc. I am using a drop down menu to select the Course, and want the times to then populate to the right, each in its own cell.
Have tried the loop code available on a few different topics here however has not quite worked.
Hoping someone can assist

Thanks
Darren.

Hi

1) Where do you want the the output to be placed?

2) How do you want to start the macro? Button?

rylo

Hi

If I understand your situation, you can do most of it with formulas.

G3:

Please Login or Register  to view this content.

Copy down/across to cover your required area.

HTH

rylo

Thank you so much to both of you. Both examples worked a treat.

Went with yours JBeaucaire simply because it removed data from blanks cells rather than repeating the last choice.

Fantastic !!!! 2 days of fumbling around was fixed by about 10 minutes of asking those who know !!!

Darren

Hi All

One quick question .. Does the range you are drawing the info from have to be constant ?
I have just transferred the formula suuiplied into my working sheet, and it is returning a #VALUE! error if I amend the length of the column to take into account the maximum possible rows, where often some of those rows will be blank (the number of courses and races varies day to day)

Am I best to do a count to set the number of rows within the formula?

Darren

thanks for the prompt reply ...

I used a cut down example of the sheet as i read the "dont use sensitive information" warning in the forum, and wanted to also remove a lot of clutter that was not pertinent to the data i was working with. The main sheets is hundreds of rows and many columns, but the standard formula should let me adapt it across the board.

thanks for the clarifications, I will amend my formulas accordingly.
I think it is the column()-6 that is the one throwing it out.

Appreciate your help

Darren

thank you for the options.

The Course codes (colours in the example) are the ones likely to be quite numerous, and each course will generally have a max of about 12 races. I assume that the table can work similar transposed to a column format and using the ROW as the index ?

This is how the current format sits and i would keep it that way to save confusion for those using the sheet.

I have attached the actual sheet i am working on for reference.
Column A is the Courses
Column B is the Races at each course
Column D the times for each race

Column L will be where I am selecting the major courses for the day,
and Cells M3 .. X10?? (maybe) is where the times will land.

Perfect

Thank you very much for all of your assistance.
It is greatly appreciated.

Darren