redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Can someone help with code that will look down range B1:B50 and when a minus sum is found, delete that cell and the adjacent value in column A, then remove those blank cells. Not remove entire row - just blank cells in columns A:B
example
would result after code...
Thanks in advnce
example
Test 1 | 200 |
Test 2 | -300 |
Test 3 | 1345 |
would result after code...
Test 1 | 200 |
Test 3 | 1345 |
Thanks in advnce