HW#9 - Recording VB Macros

The following spreadsheet is used to estimate concrete quantities and costs:

Click here to download a copy of this spreadsheet.

Record the following three macros:

(Note: Use the sort tool while recording (Data|Sort and Filter|Sort))

Macro Name Usage
sort_by_item Sorts the table by item # in ascending order
sort_by_concrete Sorts the table by concrete cost in descending order
sort_by_rebar Sorts the table by rebar cost in descending order.

Test your macros to make sure they work properly.

Submittal Instructions:

1. Be sure to save the changes to your spreadsheet.

2. Upload your spreadsheet via Learning Suite.