Prepare to export macros from state Microsoft Excel
1to20 click data click edit click file click format click insert click tools
click view click window copy <direction> <1to20> cells data sort data subtotals direction dot dot
enter key file open file save finish formula go home insert column insert row
next sheet ok previous sheet print preview select <direction> <1to20> cells select column select line
sum column v look up