In this video I show you how to use a simple macro to create a pivot table and quickly format it. Then how to slightly edit the VBA code in-order to make the macro work for a table with any number of rows so the table can have a dynamic range.
-------------------------------------------------------------------------
#exceltutorials #excelmacros #excelpivottables
SUBSCRIBE: [ Ссылка ]
VIDEO INFO: These data are related to my PhD research.
-------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- Another video where I use a macro: 'How to use powerpoint to compare NAME plots with concentrations'
[ Ссылка ]
- 'How to group columns in a pivot table' [ Ссылка ]
- 'How to link an ActiveX control textbox to a cell in excel' [ Ссылка ]
Simple pivot table using an excel macro
Теги
Microsoft ExcelExcel 2016pivot tablespivot table macromacros in excelexcel macrosmake a pivot table with a macromaking pivot tables with macrospivot table macro vbapivot table macro codepivot table macro errorhow to create pivot table using macrohow to make a pivot table using a macro in excelmacro to make a pivot tablemacro to make a pivot table in excelexcel macro pivot tableexcel macro to make a pivot table