Muhammad Hussaan
New Member
- Joined
- Dec 13, 2017
- Messages
- 49
- Office Version
- 2013
- Platform
- Windows
Hello,
I need help to avoid alot of manual work and error.
I have sheet with width of material in row 4 column C to AV and possible cut patterns in row 5 to 103 in column C to AV having values of 0 to 5. I want the width against non zeros and number of times if it is greater than 1. As in Row 5 only two values are greater than ZERO in range C:5 to AV5 and values are 1 and 2 in cell V5 and Z5 respectively and againts these cells in row 4 we have 56 and 60. 56 has 1 in row 5 and 60 has 2 in row 5 therefore i write it as 56 |60 |60 columns AZ to BF manually.
How to to it by some formula or vba macro?
Kindly help.
Thanks
I need help to avoid alot of manual work and error.
I have sheet with width of material in row 4 column C to AV and possible cut patterns in row 5 to 103 in column C to AV having values of 0 to 5. I want the width against non zeros and number of times if it is greater than 1. As in Row 5 only two values are greater than ZERO in range C:5 to AV5 and values are 1 and 2 in cell V5 and Z5 respectively and againts these cells in row 4 we have 56 and 60. 56 has 1 in row 5 and 60 has 2 in row 5 therefore i write it as 56 |60 |60 columns AZ to BF manually.
How to to it by some formula or vba macro?
Kindly help.
Thanks