User Profile
SamFares
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
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,SamVBA Copying data from certain columns one sheet to rows in another sheet
Hello, There are two tabs in my Excel Book. The data source (data copied from) is (Jedi WN joists) tab to be pasted into the rows in (Span=50', Depth=26"-48"). I indicated in column "O" in (Span=50', Depth=26"-48") tab, the column addresses of(Jedi WN joists) tab that need to be copied and pasted into (Span=50', Depth=26"-48"). I showed in row5 &6 of(Span=50', Depth=26"-48")an example of the data copied from(Jedi WN joists, AD2-AD11) and transposed and pasted into(Span=50', Depth=26"-48").i 'd like to have a macro button that automate the copying and pasting for the rest of the rows of (Jedi WN joists). In column P of(Span=50', Depth=26"-48") I indicated the Marks the corresponding Marks which are in column A of(Jedi WN joists). I am attaching my excel book. Thank you in advance! SamSpeeding up VBA execution
Hello, In the attached excel sheet, i added the "Composite" and "FloorData" tabs to my excel sheet. Those two tabs are not linked to other tabs in the sheet. When the tabs are in a separate excel sheet, the macro " Click to Calculate" runs in a second, but when it is within this excel sheet it runs for nearly two minutes even though it is not linked to other tabs. "Composite" tab password: chickenhawk VBA password: csirocks in the "Composite" Tab: key in in cell H27= 2 key in in cell H28= 150 key in in cell H29= 8 "Click to Calculate" macro which is placed near cell G50. before you run it it is in light red then it turns green when it is done. I don't know how to make the macro much faster. for some reason it slows down big time. Like i said earlier these two tabs are not linked to the Thank you, Sam
