Populate rows on sheets based on a cell content

[kc8jpk03]

Hello,

I have one more issue. I would like to pull the entire row of data from the "Master" sheet to the respective tab based on the "Event" or "Code". I have formatted all of the tabs to the appropriate sizes and column headers to match the "Master" Sheet. In other words, I want to enter everyone's data on the "Master" sheet, and depending on the "Event" or "Code", I want the entire row, to populate the respective "Event" and "Code" sheets. I have attached the form for reference.

Also, I have noticed that the "Event" Drop Box does not require a selection from the list as it should, it allows any entry. It also does not populate based on what you start to type. For Instance, if I type an "I", it doesn't jump to "ICAC", I can type IC and hit tab, it will allow the entry even though I have set the Error tab to say "Stop".

Thank you for your time and consideration.

Mike

[oeldere]

you are on an excel forum, please attach an excel file.

[kc8jpk03]

I tried, it was too large so I uploaded screen shots of what I was trying to accomplish in pasted in a word document.

[kc8jpk03]

Here is a link to my spreadsheet: https://www.dropbox.com/s/pkp6cbjbk1...tics.xlsx?dl=0

[JeteMc]

I am going to try to give an explanation of how this could be done, and also am attaching a sample of your master sheet (values only) and a couple (W607 & S120) of the Code sheets, with the formulas and conditional formatting applied.
In the Code sheets:
1) Paste the following formula in E4 and copy down as far as needed: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

A)You could hide the lines that are not yet used with a conditional formatting rule: =$A4="" Applies to =$E:$E Format > Font > no color

2) Paste the following array formula* in A4 and copy down as far as needed: =IFERROR(INDEX(Master!A$4:A$20,SMALL(IFERROR((ROW(A$1:A$20)/(Master!$E$4:$E$20=$E4)),FALSE),ROW(A1))),"")

A) *Activate the formula by pressing the F2 key then press CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER All of the values in column A will be the same.

B) You'll need to format column A to Date.

3) Drag the fill handle of A4 across to D4 and then down as far as needed.

A) You'll need to format column B to time.

4) Select D4 and press Ctrl + c
5) Select F4 and press Ctrl + v
6) Drag the fill handle of F4 across to H4 and down as far as needed.

A) Change the format of column H to general

B) You may want to apply a conditional formatting rule to column H to hide the zeroes: CF rule =$H4=0 Applies to =$H:$H Format > Font > no color

Let me know if you have any questions.