Trebor8484
Board Regular
- Joined
- Oct 27, 2018
- Messages
- 69
- Office Version
- 2013
- Platform
- Windows
Hi all,
Can anyone assist with a vba solution to the below problem please.
So I have from column I to column R columns labelled as follows:
Job Desc 1
Quantity 1
Job Desc 2
Quantity 2
Job Desc 3
Quantity 3
Job Desc 4
Quantity 4
Job Desc 5
Quantity 5
What I need to do is, working from right to left identify if there are any charges listed in Job Desc 5/Quantity 5. If there are but Job Desc 4/Quantity 4 are empty then it needs to move the values from Job Desc 5/Quantity 5 into Job Desc 4/Quantity 4. Basically, there can be no empty columns. If there are charges then they need to be populated in Job Desc 1/Quantity 1 first before moving across.
[/IMG]
Thanks
Can anyone assist with a vba solution to the below problem please.
So I have from column I to column R columns labelled as follows:
Job Desc 1
Quantity 1
Job Desc 2
Quantity 2
Job Desc 3
Quantity 3
Job Desc 4
Quantity 4
Job Desc 5
Quantity 5
What I need to do is, working from right to left identify if there are any charges listed in Job Desc 5/Quantity 5. If there are but Job Desc 4/Quantity 4 are empty then it needs to move the values from Job Desc 5/Quantity 5 into Job Desc 4/Quantity 4. Basically, there can be no empty columns. If there are charges then they need to be populated in Job Desc 1/Quantity 1 first before moving across.
![2qso2g6.png](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttp%3A%2F%2Fi63.tinypic.com%2F2qso2g6.png&hash=ced625af473b0eb6a545d139d5fdf833)
Thanks