Simple pivot table using an excel macro

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: https://goo.gl/c46YPs

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'
Using powerpoint to investigate chang...
- 'How to group columns in a pivot table' How to group columns in a pivot table
- 'How to link an ActiveX control textbox to a cell in excel' How to link an ActiveX control textbo...

• #science_technology
• #microsoft_excel
• #excel_2016
• #pivot_tables
• #pivot_table_macro
• #macros_in_excel
• #excel_macros
• #make_a_pivot_table_with_a_macro
• #making_pivot_tables_with_macros
• #pivot_table_macro_vba
• #pivot_table_macro_code
• #pivot_table_macro_error
• #how_to_create_pivot_table_using_macro
• #how_to_make_a_pivot_table_using_a_macro_in_excel
• #macro_to_make_a_pivot_table
• #macro_to_make_a_pivot_table_in_excel
• #excel_macro_pivot_table
• #excel_macro_to_make_a_pivot_table