I would like to start by thanking anyone who takes their time to reply to this in advance, as I know this is not something you have to do! I have spent countless hours looking for a code that was close to borrow from or a formula that would do something even close, and at this point in time my brain hurts and nothing has worked. Youtube and Google did not manage to teach me enough:) I have apparently moved past my expertise.
I am attempting to create a spreadsheet that will take the data entered on the master sheet and transfer it to another sheet based on the outcome of a certain cell. I will attempt to create an example below and better explain.
(HFA Isolation List) Rows 1-7 are populate with other data and wont be used.
[TABLE="width: 500"]
a
b
[/td]c
[/td]d
[/td]e
[/td]f
[/td]g
[/td]1
2
[/td]3
[/td]4
[/td]5
[/td]6
[/td]7
[/td]8
[/td]no
[/td]low
[/td]high
[/td]high
[/td]eat
[/td]Blind
[/td]sleep
[/td]9
[/td]
[/TABLE]
(Blind Isolation List) Rows 1-7 are populate with other data and wont be used.
[TABLE="width: 500"]
a
[/td]b
[/td]c
[/td]d
[/td]e
[/td]f
[/td]g
[/td]1
2
[/td]3
[/td]4
[/td]5
[/td]6
[/td]7
[/td]8
[/td]no
[/td]low
[/td]high
[/td]high
[/td]eat
[/td]Blind
[/td]sleep
[/td]
[/TABLE]
Using the tables above, if my original worksheet (HFA Isolation List) has the word "Blind" in F8, then I would like the data in A8 - Q8 to transfer to another worksheet (Blind Isolation List) and input the information starting at A8 - Q8 in the (Blind Isolation List) worksheet. In addition, if in the (HFA Isolation List) worksheet there is nothing entered, I would like excel to simply move on to the next line looking for the word "Blind" in column F until it reached F:47. At any point should excel see the word "Blind", then that row of information would also transfer to the (Blind Isolation List) worksheet. And my last request would be that the (Blind Isolation List) worksheet would populate without skipping rows if the same row in the (HFA Isolation List) did not return a value in the same row. So if F:9 and F:10 did not return a value and F:11 did, then excel would transfer the information in A11 - Q11 on (HFA Isolation List) worksheet to A9 - Q9 on the (Blind Isolation List) worksheet, and I would not have empty rows.
Again, I greatly appreciate any help!!!