Papadopoulos
08-20-2010, 12:49 PM
Ok, in theory this should be really easy but it bumps up against a gap in my VBA knowledge. On one sheet I am working up an estimate. The items in the estimate end up in a list regardless of whether they have values or not. That's fine on what is essentially a worksheet. The quote however needs to be tidier.
I would like to transfer only the items who's description is not equal to none.
in the sample, Sheet 1 has the data that would typically be on the worksheet. Sheet 2 has the data as it currently appears at the top and what I would like it to look like at the bottom. If I do this like everything else in this app it will consist of a very long cumbersome If/Else If sequence so I have just left it out. I would think that it would be a matter of testing a range (not equal to None) and then storing that in a variable... increment the row by one...
Sorry, this is beyond me, at least at this moment. I will even take a link to something similar and try an decifer it myself. (Not trying to get someone to do this for me just looking for a sensible direction to head toward)
Thanks,
David
I would like to transfer only the items who's description is not equal to none.
in the sample, Sheet 1 has the data that would typically be on the worksheet. Sheet 2 has the data as it currently appears at the top and what I would like it to look like at the bottom. If I do this like everything else in this app it will consist of a very long cumbersome If/Else If sequence so I have just left it out. I would think that it would be a matter of testing a range (not equal to None) and then storing that in a variable... increment the row by one...
Sorry, this is beyond me, at least at this moment. I will even take a link to something similar and try an decifer it myself. (Not trying to get someone to do this for me just looking for a sensible direction to head toward)
Thanks,
David