User Profile
SamFares
Brass Contributor
Joined May 29, 2019
User Widgets
Recent Discussions
Re: Need a Macro for the following steps.
Hello Yea_So Each increment is 0.1. So you are incrementing up from 0.1 to 0.9. There is no basis to the size of the increment. I can choose a different increment. Did i answer your question? If for example C11 is blank just set the increment value to 0.5 for that mark. Then go to the next mark. Thanks!Need a Macro for the following steps.
Hello All, Please see attachments. I just revised the attached Excel sheet. I’d like a macro to do the following: If for a given Mark in column A of “Addl Composite Stage Loads” tab, the value in the corresponding cell “C row #” in “Addl Composite Stage Loads” is zero or blank, then skip steps 2 and 3 ( below), and go to the next Mark, and if there is a value in “C row #” greater than zero then run all the steps 2 and 3. The value in cell “G6” in “Addl Composite Stage Loads” tab will be incremented from 0.1,0.2,0.3,….,0.9. The result in cell “B4” in “CJ Design” tab will be copied and place in the corresponding cell in C4 thru K4. So if the increment value is 0.1 it will be placed in C4 if the increment value is 0.2 it will be placed in D4 if the increment value is 0.3 it will be placed in E4 and so on. Repeat the above steps for the next joist Marks Thank you,Sam
