Page break,Page subtotal,lastly grand total by a click.

Manually every page break insert row than subtotal is difficult ,if many page in a report. Lastly grand total in last page time waste because Scrolling tab and go to last page . I search this easy way it solve but not find in net .

Number to inches and feet by function .

Some time we need how to convert number to inches and feet. It is difficult by normal process but it is easy

Formula to value a click .

Formula to value a click .Here use a small Vb code when we copy something then paste another sheet problem face by this formula cell another way some time we face which formula use this are hide this are difficult but everything solve by click because all

Insert number automatically by a click

Any where click in Ms Excel row/column automatically insert number a specific column which column select in VB code and start from specific row as you select in VB .