redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hi all
Simple enough but can't get to VBA to work
Simply look through range B3:B8 and if a Zero is found then remove (Delete and move up) all data in corresponding rows A:E
so for example if a zero is found (as shown in B4) then A4:E4 is deleted (and moved up)
TIA
NAME | PROFIT | W | L | WIN % | |
DAVE | 34.75 | 1 | 0 | 1 | |
TIM | 0 | 0 | 0 | 0 | |
KEVIN | 0 | 0 | 0 | 0 | |
PETER | 0 | 0 | 0 | 0 | |
ALAN | 0 | 0 | 0 | 0 | |
PAUL | -9.84 | 0 | 1 | 0 | |
Simple enough but can't get to VBA to work
Simply look through range B3:B8 and if a Zero is found then remove (Delete and move up) all data in corresponding rows A:E
so for example if a zero is found (as shown in B4) then A4:E4 is deleted (and moved up)
TIA