One click Pivot table

[merrytess]

Hi I am managing a data with over 1000 lines that i need to summarise as pivot table but dont want to keep on inserting pivot table and having a pivot tabe on formulas.

Is there a way of doing a script or asigning a 1 click macro for this?

example data below:
Unit Ledger Account DeptID Project Amount Descriptio OperUnit
58 ACTUALS 24290965 232 871.92 PayrollNo.4Date03062019 S
58 ACTUALS 23770165 256 UPGRAD 154.89 PayrollNo.4Date03062019 W
58 ACTUALS 23770165 256 UPGRAD 154.89 PayrollNo.4Date04062019 W
58 ACTUALS 23770165 256 UPGRAD 30.98 PayrollNo.4Date05062019 W
58 ACTUALS 23770165 256 WE1049 241.8 PayrollNo.4Date09062019 W
58 ACTUALS 23770165 256 UPGRAD 154.89 PayrollNo.4Date10062019 W
58 ACTUALS 23770165 256 UPGRAD 105.32 PayrollNo.4Date11062019 W
58 ACTUALS 23770165 256 UPGRAD 24.78 PayrollNo.4Date12062019 W
58 ACTUALS 23770165 256 UPGRAD 154.89 PayrollNo.4Date14062019 W
58 ACTUALS 23770265 215 QH166 21.68 PayrollNo.4Date05062019 Q
58 ACTUALS 54250160 212 -330.84 PayrollNo.4Date16062019 Q
58 ACTUALS 54250160 260 -344.68 PayrollNo.4Date16062019 S
58 ACTUALS 54250160 224 -306.33 PayrollNo.4Date16062019 N
58 ACTUALS 54250160 245 -474.5 PayrollNo.4Date16062019 S
58 ACTUALS 54250160 254 -365.83 PayrollNo.4Date16062019 W
58 ACTUALS 54250160 254 -314.45 PayrollNo.4Date16062019 W
58 ACTUALS 54250160 281 -362.07 PayrollNo.4Date16062019 T

[Pepe Le Mokko]

Hi and welcome
do you mean you are trying to build a Pivot Table with a dynamic source range?
If so, lots of info at https://www.contextures.com/xlPivot01.html