excel - I need help arranging different values using vba code -

so have excel sheet has information user can put @ different times. problem have want user pick on cell c7 if want use server or grid, depending on answer different responses on cell (c9). in code, having problem doesn't know if user picks grid or server. add code. here code.

sub finddata() dim workflow string dim server string dim finalrow integer dim integer  workflow = sheets("sheet1").range("c5").value server = sheets("sheet1").range("c9").value grid = sheets("sheet1").range("c9").value  finalrow = sheets("sheet3").range("c100").end(xlup).row  = 5 finalrow     if cells(i, 3) = workflow     if cells(i, 4) = server     if cells(i, 5) = grid     range(cells(i, 2), cells(i, 12)).copy     range("j42").end(xlup).offset(1, 0).pastespecial xlpasteformulasandnumberformats     end if     end if     end if next  end sub 

why not approach instead?

sub finddata() dim workflow string dim finalrow integer dim integer  workflow = sheets("sheet1").range("c5").value  finalrow = sheets("sheet3").range("c100").end(xlup).row  = 5 finalrow     if cells(i, 3) = workflow ' 1. if cells(i, 3) = workflow     if cells(i, 4) = "server" ' 2. if cells(i, 4) = "server"     range(cells(i, 2), cells(i, 12)).copy     range("j42").end(xlup).offset(1, 0).pastespecial xlpasteformulasandnumberformats     elseif cells(i, 4) = "grid" ' 2. if cells(i, 4) = "server"     else ' 2. if cells(i, 4) = "server"     'not handled     end if ' 2. if cells(i, 4) = "server"     end if ' 1. if cells(i, 3) = workflow next  end sub