tommiexboi
New Member
- Joined
- Apr 24, 2017
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
Hello Everyone!
Purpose
I'm creating a forecast tool that lists both quantity and price. I need the users to make sure that if they enter a quantity then they need to input a price.
Objective
I want to create a macro where it'll loop through the data and check if there's a quantity there's also a price. If there's no price, then it'll list the Customer, Item Number, and which month it's missing from on a separate sheet.
Example Data:
<tbody>
</tbody>
Result in separate sheet:
<tbody>
</tbody>
Need Help:
I have tried to look through the vast amount of information on the internet, however; this specific case seems hard to find. Is there a way I can create a macro to do this or a formula that can replicate this?
Any help or direction will be greatly appreciated!
Thank you
Purpose
I'm creating a forecast tool that lists both quantity and price. I need the users to make sure that if they enter a quantity then they need to input a price.
Objective
I want to create a macro where it'll loop through the data and check if there's a quantity there's also a price. If there's no price, then it'll list the Customer, Item Number, and which month it's missing from on a separate sheet.
Example Data:
Customer | Item | Month 1 | Month 2 | Month 3 | Month 1 Price | Month 2 Price | Month 3 Price | ||
X | ABC-123 | 50 | 100 | 200 | $5.00 | $3.00 | $0.00 | ||
Z | XYZ-456 | 100 | 50 | 100 | $0.00 | $1.00 | $0.00 |
<tbody>
</tbody>
Result in separate sheet:
Customer | Item | Month | ||
X | ABC-123 | Month 3 | ||
Z | XYZ-456 | Month 1 | ||
Z | XYZ-456 | Month 3 | ||
<tbody>
</tbody>
Need Help:
I have tried to look through the vast amount of information on the internet, however; this specific case seems hard to find. Is there a way I can create a macro to do this or a formula that can replicate this?
Any help or direction will be greatly appreciated!
Thank you