Hi Guys,
I would like to ask if my idea is possible and doable. Currently, I have two worksheets (System Network and AttackReport). I want to copy or reference specific cells if the value of cells in Column B in System Network sheet is equal to NetworkAttack.
If ColumnB=NetworkAttack, I want to reference or copy of that row:
- ColumnA in System Network worksheet to ColumnA in AttackReport worksheet
- ColumnC in System Network worksheet to ColumnB in AttackReport worksheet
- ColumnE in System Network worksheet to ColumnF in AttackReport worksheet
- ColumnF in System Network worksheet to ColumnG in AttackReport worksheet
- ColumnG in System Network worksheet to ColumnI in AttackReport worksheet
- ColumnH in System Network worksheet to ColumnJ in AttackReport worksheet
- ColumnI in System Network worksheet to ColumnL in AttackReport worksheet
- ColumnJ in System Network worksheet to ColumnM in AttackReport worksheet
Could this be possible?
Thanks in advance!
I would like to ask if my idea is possible and doable. Currently, I have two worksheets (System Network and AttackReport). I want to copy or reference specific cells if the value of cells in Column B in System Network sheet is equal to NetworkAttack.
If ColumnB=NetworkAttack, I want to reference or copy of that row:
- ColumnA in System Network worksheet to ColumnA in AttackReport worksheet
- ColumnC in System Network worksheet to ColumnB in AttackReport worksheet
- ColumnE in System Network worksheet to ColumnF in AttackReport worksheet
- ColumnF in System Network worksheet to ColumnG in AttackReport worksheet
- ColumnG in System Network worksheet to ColumnI in AttackReport worksheet
- ColumnH in System Network worksheet to ColumnJ in AttackReport worksheet
- ColumnI in System Network worksheet to ColumnL in AttackReport worksheet
- ColumnJ in System Network worksheet to ColumnM in AttackReport worksheet
Could this be possible?
Thanks in advance!