Learn

Download Books & Software

Our New E-Store -> AnyTechKey.com

Menu

enter data by range in excel

Macro 77: Transpose Entire Data Range with a PivotTable

Leave a Comment / Civil Engineering Projects / / , , , , ,

Macro 77: Transpose Entire Data Range with a PivotTable You may often encounter matrix-style data tables like the one shown in Figure 6-6. The problem is that the month headings are spread across the top of the table, pulling double duty as column labels and actual data values. In a PivotTable, this format would force […]

Macro 77: Transpose Entire Data Range with a PivotTable Read More »

Macro 35: Inserting Blank Rows in a Range

Leave a Comment / Civil Engineering Projects / / , , , , , ,

Macro 35: Inserting Blank Rows in a Range Occasionally, you may need to dynamically insert rows into your dataset. Although blank rows are generally bothersome, in some situations, the final formatted version of your report requires them to separate data. The macro in this section adds blank rows into a range. How it works This

Macro 35: Inserting Blank Rows in a Range Read More »

Share knowledge