tag:blogger.com,1999:blog-24066970568137990362024-11-08T21:40:51.385+06:00MS EXCEL TIPS , FUNCTION ,TUTORIAL ETC.Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.comBlogger70125tag:blogger.com,1999:blog-2406697056813799036.post-10877367998142100712014-10-17T19:27:00.000+06:002014-10-17T19:41:32.390+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFGp8czG7Fl6_AVg80Mf74Qp-0AwCUdEss5NIuFVURWN96oVwKRjOanrtEbMRTzEmK2AHuklQKcOqjU1t9vtf6xFygmBxBzTlabvG5idyRh6K52fYmWydfgf508PbLpwcAIfuYslbNrt_D/s1600/Row+and+column.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFGp8czG7Fl6_AVg80Mf74Qp-0AwCUdEss5NIuFVURWN96oVwKRjOanrtEbMRTzEmK2AHuklQKcOqjU1t9vtf6xFygmBxBzTlabvG5idyRh6K52fYmWydfgf508PbLpwcAIfuYslbNrt_D/s1600/Row+and+column.jpg" height="190" width="320"></a></div> <br> Row and column sum by easy formula. By this formula easily know rows sum and column sum are equal or not . This formula easily identify rows sum and column sum right or wrong.<br> <a href="http://shaifulaueo.blogspot.com/2014/10/row-and-column-sum-by-easy-formula.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-6488058595832402542014-03-17T23:15:00.000+06:002014-03-17T23:15:06.249+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuoj-4YOHpJqI2LyCUxDK4SrruXA7aDCIIYOHyqu3aTIX1gvT17fqM9AE1KwkIb5xVknZV9ugoevFvWxSzaqx7lbXKH8ZYOjFxHOivCR87tJ0fcIFLpcqy_W_DB1tUeNhHqBhKp4s8kzfO/s1600/Unique+value+identify.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuoj-4YOHpJqI2LyCUxDK4SrruXA7aDCIIYOHyqu3aTIX1gvT17fqM9AE1KwkIb5xVknZV9ugoevFvWxSzaqx7lbXKH8ZYOjFxHOivCR87tJ0fcIFLpcqy_W_DB1tUeNhHqBhKp4s8kzfO/s1600/Unique+value+identify.jpg" height="190" width="320"></a></div> Unique value easily Identify by conditional formatting a formula . Some time we are need only unique value from report ,If this report range large difficult to manually find unique value. so ,we are use this formula.<br> <a href="http://shaifulaueo.blogspot.com/2014/03/unique-value-easily-identify.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-48698132109359924592013-04-14T12:11:00.000+06:002013-04-14T12:11:57.598+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-HWCiATdRlU5j5C8YH5M5tSsMBv_8p0x4Q6UaZNiujQg2cSrl88cfeZwG-6ZQVwi6DTPK4IEPmwJ5SOeDheUPMMMTeafyf-znt73PrAs2attBjmBr94c7KHmp2fuF9CLJeB6weOnraoz0/s1600/Page+breck,Sub+and+Grand+total.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Page break,sub total,Grand total." border="0" height="190" img="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-HWCiATdRlU5j5C8YH5M5tSsMBv_8p0x4Q6UaZNiujQg2cSrl88cfeZwG-6ZQVwi6DTPK4IEPmwJ5SOeDheUPMMMTeafyf-znt73PrAs2attBjmBr94c7KHmp2fuF9CLJeB6weOnraoz0/s320/Page+breck,Sub+and+Grand+total.jpg" width="320"></a></div> 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 .<br> <a href="http://shaifulaueo.blogspot.com/2013/04/page-breakpage-subtotallastly-grand.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com4tag:blogger.com,1999:blog-2406697056813799036.post-14725722085777930662013-01-28T23:00:00.000+06:002013-01-28T23:00:37.732+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAbZRh5StnQ_sl88x9xro06WUtZgfr5TYGz7PnrVRsfWD07GkPKcBduE4oxmqH9LYqbwwOiBAJ_KDN99L3tqU8GUj9RzarbPKwimEYqT7NAyyidC-1nOh2uU9H-pusjNUQq4k4cyYH-8cM/s1600/Number+convert+feet+and+inch.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Number to inches and feet." border="0" height="190" img="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAbZRh5StnQ_sl88x9xro06WUtZgfr5TYGz7PnrVRsfWD07GkPKcBduE4oxmqH9LYqbwwOiBAJ_KDN99L3tqU8GUj9RzarbPKwimEYqT7NAyyidC-1nOh2uU9H-pusjNUQq4k4cyYH-8cM/s320/Number+convert+feet+and+inch.jpg" width="320"></a></div> <div style="text-align: justify;"> Some time we need how to convert number to inches and feet. It is difficult by normal process but it is easy</div> <a href="http://shaifulaueo.blogspot.com/2013/01/number-to-inches-and-feet-by-function.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-13419111457311520772012-12-15T22:27:00.000+06:002013-01-16T00:04:35.292+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtYkal96K3xkGVdLDzjlBPwVUXsurQMhu68RtRQNx3kMRKPBJWoHPRFl2-HJna012u-P8xCCK6FdOLspRrdDQJIode4UkblaSxrNOF8wS92YYMw-ljBjk6MgTHlz5cGL8SPNLdkH1HBaeA/s1600/Formula+to+value.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Formula to value." border="0" height="190" img="img" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtYkal96K3xkGVdLDzjlBPwVUXsurQMhu68RtRQNx3kMRKPBJWoHPRFl2-HJna012u-P8xCCK6FdOLspRrdDQJIode4UkblaSxrNOF8wS92YYMw-ljBjk6MgTHlz5cGL8SPNLdkH1HBaeA/s320/Formula+to+value.jpg" width="320"></a></div> 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 <br> <a href="http://shaifulaueo.blogspot.com/2012/12/formula-to-value-click.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-77976973146028656022012-11-28T00:18:00.001+06:002012-11-28T00:18:38.521+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggwYURQ3GFuBPu31uoj8R2Ds-J0Q5jVNdJJQnaQYHo9OXv84CfRc7Uo55sb-45A0XShQF5NHvSJ_G8Ot55dU-qCkNRkuBXPNslK_6wKUzgbNhUS-9dI4EiF_rZXvIrjJQWBdo5D4ZFfdhp/s1600/Insert+auto+number.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Insert Auto number." border="0" height="190" img="img" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggwYURQ3GFuBPu31uoj8R2Ds-J0Q5jVNdJJQnaQYHo9OXv84CfRc7Uo55sb-45A0XShQF5NHvSJ_G8Ot55dU-qCkNRkuBXPNslK_6wKUzgbNhUS-9dI4EiF_rZXvIrjJQWBdo5D4ZFfdhp/s320/Insert+auto+number.jpg" width="320"></a></div> <br> 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 . <br> <a href="http://shaifulaueo.blogspot.com/2012/11/insert-number-automatically-by-click.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-51639070227245667602012-11-16T15:38:00.000+06:002012-11-18T23:50:04.063+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEgiEBAavoWfyMbpWhPLrzdANYpCPhZ_A97uf4DvFiEusHmSLy7AnckOFJTdca-sEdO5832S0YwHiC_zB99nRqHd3V-cnOgmt8zedpxMK30uT1BtcsgLcIaSy32Bvpas9LLr7Cuu1bXt6b/s1600/filtered+column+Header+row+color.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Filtered column head color." border="0" height="190" img="img" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEgiEBAavoWfyMbpWhPLrzdANYpCPhZ_A97uf4DvFiEusHmSLy7AnckOFJTdca-sEdO5832S0YwHiC_zB99nRqHd3V-cnOgmt8zedpxMK30uT1BtcsgLcIaSy32Bvpas9LLr7Cuu1bXt6b/s320/filtered+column+Header+row+color.jpg" width="320"></a></div> When different column filtered in ms excel , some time face which /which which column filtered. In this time, we try every column tab click and set in this way time waste and brain pressure increases. <br> <a href="http://shaifulaueo.blogspot.com/2012/11/filtered-column-heading-row-cell-color.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-38508678695427826072012-10-17T00:53:00.000+06:002012-11-17T23:53:44.111+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwtZf33TabWcpu6TkvE11BwJNWsYEovUUrpiz0WXyJeVznD1y_zU8jYaIdS3iTqzGontJIdeMBmOfM2dKMriF233H_VgnnlYvAxiemvuNtvJ0_RhZU0EdRq_LSfJ3EJubPadjNTQ_dsPqo/s1600/face+id+with+picture.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Face ID and picture." border="0" height="190" img="img" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwtZf33TabWcpu6TkvE11BwJNWsYEovUUrpiz0WXyJeVznD1y_zU8jYaIdS3iTqzGontJIdeMBmOfM2dKMriF233H_VgnnlYvAxiemvuNtvJ0_RhZU0EdRq_LSfJ3EJubPadjNTQ_dsPqo/s320/face+id+with+picture.jpg" width="320"></a></div> <br> As a programmer and developer need face ID for command bar , menu bar, tool bar etc developed. Several <br> <a href="http://shaifulaueo.blogspot.com/2012/10/face-id-number-with-picture.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-26000546575777185232012-09-28T21:23:00.000+06:002012-11-11T02:45:22.819+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJt5751rUS0vUf8VEdIqvndBCcsv5B4oAQPf4y0WG5PBY3z2utwTM_se0RU4W280rNJp48NYvJEegbrrSQG-7qIJkQGhy_SJKSopfLXf06jYRtIno5yEb0gqI8EqKAe7q4FPneCST3I-2a/s1600/Define+function.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Define function." border="0" height="190" img="img" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJt5751rUS0vUf8VEdIqvndBCcsv5B4oAQPf4y0WG5PBY3z2utwTM_se0RU4W280rNJp48NYvJEegbrrSQG-7qIJkQGhy_SJKSopfLXf06jYRtIno5yEb0gqI8EqKAe7q4FPneCST3I-2a/s320/Define+function.jpg" width="320"></a></div> <br> Some time need a function for easy work/reporting . But don&#39;t work memory how it is possible in ms excel .it<br> <a href="http://shaifulaueo.blogspot.com/2012/09/function-create-by-vb-and-use.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-29490807084299918242012-09-09T23:22:00.000+06:002012-11-14T23:30:47.867+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFcNG-Ej8Rohdg9Dweh-d-zJpLHIA-QZpkKOrmzLNhTgYlSYoIX3jJJWlZii_fIlv6bZ99q8v5A-S_A47tS1LnZ8IlWXTAeH9XWZs393ggSiGSjlav4xk4Wx7hpwAmBhmSqV4YToBxbIq6/s1600/Odd+or+even+row+color.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Odd or Even cell color." border="0" height="190" img="img" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFcNG-Ej8Rohdg9Dweh-d-zJpLHIA-QZpkKOrmzLNhTgYlSYoIX3jJJWlZii_fIlv6bZ99q8v5A-S_A47tS1LnZ8IlWXTAeH9XWZs393ggSiGSjlav4xk4Wx7hpwAmBhmSqV4YToBxbIq6/s320/Odd+or+even+row+color.jpg" width="320"></a></div> <br> Some time need to odd row or even row color in ms excel sheet for easy way working.But manually this work is very difficult and time killing .Easy way solve this thing, at first sheet select than go to menu bar click<br> <a href="http://shaifulaueo.blogspot.com/2012/09/odd-or-even-row-color-easy-way.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-70914025993514794212012-08-16T17:55:00.001+06:002012-11-11T02:46:37.953+06:00<br> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvC13z0aaY1mBHfOy5I7efMoUfKnNSdloZ5D5WGTUUiQYXfLsLZC6mw-1kD2RDKmIyBHABINURvkYhX12eYkf7io70XESi755RwWK7Iboruv8FRccYWWpA83NlV69h-wJGtku10ohGZAZJ/s1600/Combine+two+or+more+coloumn.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Combine cell."img border="0" height="190" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvC13z0aaY1mBHfOy5I7efMoUfKnNSdloZ5D5WGTUUiQYXfLsLZC6mw-1kD2RDKmIyBHABINURvkYhX12eYkf7io70XESi755RwWK7Iboruv8FRccYWWpA83NlV69h-wJGtku10ohGZAZJ/s320/Combine+two+or+more+coloumn.jpg" width="320"></a></div> Before I post How to combine two or more column cell by  <a href="http://shaifulaueo.blogspot.com/2012/03/combine-two-or-more-cell-data-in-one.html">Combine function</a> .Now this combine process very easy VB code .<br> <a href="http://shaifulaueo.blogspot.com/2012/08/combine-two-or-more-column-cell-by.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com2tag:blogger.com,1999:blog-2406697056813799036.post-52334320465622548132012-08-12T00:58:00.000+06:002012-11-12T00:42:32.254+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAFvfwZvYH89SeI7Kysm6DaC_qr5sIaxOWZ9hahEJcX9ZzPDuDItkkMqbPS0ktiStGOzyXKrQpd9pKJgj5w1qfzf6g97cycKWSsgTo0qRa6LwJSQTHdSs-l3iUEufPHfqeH-M0x-HlnLXg/s1600/Colore+name+Know.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Color know." border="0" height="190" img="img" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAFvfwZvYH89SeI7Kysm6DaC_qr5sIaxOWZ9hahEJcX9ZzPDuDItkkMqbPS0ktiStGOzyXKrQpd9pKJgj5w1qfzf6g97cycKWSsgTo0qRa6LwJSQTHdSs-l3iUEufPHfqeH-M0x-HlnLXg/s320/Colore+name+Know.jpg" width="320"></a></div> In Ms excel by VB very easy know color name. Some time it is very important to us whats name is color .So<br> <a href="http://shaifulaueo.blogspot.com/2012/08/color-name-know-easily.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com1tag:blogger.com,1999:blog-2406697056813799036.post-43295116688460042912012-07-24T23:29:00.001+06:002012-11-12T00:45:37.279+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6VnzLSKRK5fH8-ZVyxjdkhsekFJ60E5osRli1nOaYqLuacsmruBjpW4iM0PX7cpX0eRBxQ0VeOwr_xiko6g65Uwc4bm84Hcri2a_V4O9fD7ANhn0b6qWA6M2mdb2fPepo-WjPiEjAw0h6/s1600/Email+extrator.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Email extract." border="0" height="190" img="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6VnzLSKRK5fH8-ZVyxjdkhsekFJ60E5osRli1nOaYqLuacsmruBjpW4iM0PX7cpX0eRBxQ0VeOwr_xiko6g65Uwc4bm84Hcri2a_V4O9fD7ANhn0b6qWA6M2mdb2fPepo-WjPiEjAw0h6/s320/Email+extrator.jpg" width="320"></a></div> Some time we feel difficult to Email address Extract from string .Because it is time waste at first copy than paste other <span style="background-color: white;">place . But it is easy way extract it by visual basic code writing for </span><span style="background-color: white;"> create a function than it is use </span><br> <a href="http://shaifulaueo.blogspot.com/2012/07/extract-email-address-from-string.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-54082703698152126692012-07-16T17:13:00.000+06:002012-11-12T00:47:10.565+06:00<div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkJewc064pPgmapBwSqTg4DEhJk3qtaejueor7mfPTVPYsCEUvLCcbnMThqzXMF4Wz2FsxHA6qNXEKLQ9HhUa9gLOeMHCXObcmytzeDfzKNXRQIYBMyVYJmkD8r9YQFJnuv4JeTW8omef3/s1600/Select+same+color.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Specific color cell." border="0" height="192" img="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkJewc064pPgmapBwSqTg4DEhJk3qtaejueor7mfPTVPYsCEUvLCcbnMThqzXMF4Wz2FsxHA6qNXEKLQ9HhUa9gLOeMHCXObcmytzeDfzKNXRQIYBMyVYJmkD8r9YQFJnuv4JeTW8omef3/s320/Select+same+color.jpg" width="320"></a></div> At first cursor click where ,which color cell select than in manue bar tools click run macro (or click button) Auto slected which color you select.<br> <a href="http://shaifulaueo.blogspot.com/2012/07/specific-color-cell-content-select-one.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com1tag:blogger.com,1999:blog-2406697056813799036.post-31529621509614411712012-06-28T22:57:00.000+06:002012-11-14T23:45:34.421+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicd0w6OPNHvlsKE9AD8WQrHS-b6DZ8BELpZTWjsBkhRc8EMP3XHG8geK5YDnyepSKaGgadNbT_72EHLRN4RO5j_PHHhGWYbR-UMKSRMWderZbn4GPAKj5xK-C4HlhzfuifekUqjq1pVl_A/s1600/Date+sum+with+number.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Date sum with number." border="0" height="192" img="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicd0w6OPNHvlsKE9AD8WQrHS-b6DZ8BELpZTWjsBkhRc8EMP3XHG8geK5YDnyepSKaGgadNbT_72EHLRN4RO5j_PHHhGWYbR-UMKSRMWderZbn4GPAKj5xK-C4HlhzfuifekUqjq1pVl_A/s320/Date+sum+with+number.jpg" width="320"></a></div> <div class="separator" style="clear: both; text-align: left;"> Date to date sum very easy.But Some time need date sum with number in this time we feel this is difficult...</div> <a href="http://shaifulaueo.blogspot.com/2012/06/date-sum-with-number.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-50174977434669808882012-06-20T23:51:00.000+06:002012-11-12T00:49:36.938+06:00<div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKO_IZwbKBPkSzQKWBa2HkFWO6H8TVsDhdCHqKiaRqmIaFBJqAmewoydcFuuRcZMPCDfAEmHnp9w-t4wl19tI0rNAxhOuep1bP3yK3Nobehp3H-ucEy6pkasQ8nkWM7SS0X894-2BaBVYa/s1600/Extract+Number.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKO_IZwbKBPkSzQKWBa2HkFWO6H8TVsDhdCHqKiaRqmIaFBJqAmewoydcFuuRcZMPCDfAEmHnp9w-t4wl19tI0rNAxhOuep1bP3yK3Nobehp3H-ucEy6pkasQ8nkWM7SS0X894-2BaBVYa/s320/Extract+Number.jpg" width="320"></a></div> <div class="separator" style="clear: both; text-align: left;"> It is difficult extract number from string. Because , manually extract is not easy and killing time . If you use simple Vb.....</div> <a href="http://shaifulaueo.blogspot.com/2012/06/extract-number-from-string.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com1tag:blogger.com,1999:blog-2406697056813799036.post-78078093700677800732012-06-14T22:45:00.000+06:002012-11-12T21:23:57.895+06:00<div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-VHGivYw0UZTLAVRDGhzH7VV89wPcc2x5HdI7WKjxI9rCIe3n6RcmCz04GkRhutAF8m34IeNjPj8G3zdil79wAJr7npODnY5f8e7UI0AWm8AOcH-G0O5Myw627KrjdsII_H_8EdAsZbf9/s1600/Error+function+symbol.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Error Funtion symbol."img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-VHGivYw0UZTLAVRDGhzH7VV89wPcc2x5HdI7WKjxI9rCIe3n6RcmCz04GkRhutAF8m34IeNjPj8G3zdil79wAJr7npODnY5f8e7UI0AWm8AOcH-G0O5Myw627KrjdsII_H_8EdAsZbf9/s320/Error+function+symbol.jpg" width="320"></a></div> <div class="separator" style="clear: both; text-align: left;"> <br></div> <div class="separator" style="clear: both; text-align: left;"> Some time we don&#39;t know which type of error function by error symbol. So, i explain which symbol which </div> <div class="separator" style="clear: both; text-align: left;"> </div> <a href="http://shaifulaueo.blogspot.com/2012/06/error-function-different-type-symbol-in.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-37448233255402787792012-05-22T18:09:00.000+06:002012-11-16T00:04:50.588+06:00<div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEVHk2Lueo6exNrZLwy1cBdeBRKjLE1j8o5I2lNEIYZ7nVVMbKAf4qbSrFFJvRVacHaD9uUHMlkevs8DGyxJc1GjXGWB2QGukv2ECrbPVe_tzuQex_liDIbGHoATPwzykv6h-qKTbzcYn0/s1600/Password+multiple+user.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Password use Multiple." border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEVHk2Lueo6exNrZLwy1cBdeBRKjLE1j8o5I2lNEIYZ7nVVMbKAf4qbSrFFJvRVacHaD9uUHMlkevs8DGyxJc1GjXGWB2QGukv2ECrbPVe_tzuQex_liDIbGHoATPwzykv6h-qKTbzcYn0/s320/Password+multiple+user.jpg" width="320"></a></div> Multiple user open sheet by different username and password(own user name and password) in Ms Excel.Generally in Ms Excel one user protect sheet by a password .<br> <a href="http://shaifulaueo.blogspot.com/2012/05/multiple-user-open-sheet-by-different.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com6tag:blogger.com,1999:blog-2406697056813799036.post-71448664183111949552012-05-21T18:06:00.000+06:002012-11-12T22:08:32.592+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_Y1aBdaV2EBtbnWF3M-aA22h2lnHU2OAHjPpEY8Dgl_beo4x5CS42Vk1n_IhTI0uFpNngR-nqdPZzREOiysKlLmrPdhBRzudl8uWSEJ74iqXV2-SjTYrtSrsbfj734lPZv8MvpEUSQBBL/s1600/Excel+to+word.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Excel to word." border="0" height="192" img="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_Y1aBdaV2EBtbnWF3M-aA22h2lnHU2OAHjPpEY8Dgl_beo4x5CS42Vk1n_IhTI0uFpNngR-nqdPZzREOiysKlLmrPdhBRzudl8uWSEJ74iqXV2-SjTYrtSrsbfj734lPZv8MvpEUSQBBL/s320/Excel+to+word.jpg" width="320"></a></div> Ms Excel to Ms Word data transfer is easy process by one click.Different time we trouble feel Ms Excel data transfer to Ms word. Manually process at first excel data copy than this data paste word file is boring.So,Use <br> <a href="http://shaifulaueo.blogspot.com/2012/05/ms-excel-to-ms-word-data-transfer-by.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-70038414846195227572012-04-27T21:50:00.000+06:002012-11-15T23:22:28.306+06:00<div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1lYLtp0Q76tRYmw_HwsfPAMX5dJTRLLpYcqlDvhznEe45EinUkekxgBiHXBOhl8i7RU16RQ_f_-XAIcBgwojx3jOFVIsLCNdLIoDysKpimxWuSnz-4ZY68PstexD9CxqGlCChUwaoNzJG/s1600/sum+same+color+cell.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Sum same color&#39;s cell." border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1lYLtp0Q76tRYmw_HwsfPAMX5dJTRLLpYcqlDvhznEe45EinUkekxgBiHXBOhl8i7RU16RQ_f_-XAIcBgwojx3jOFVIsLCNdLIoDysKpimxWuSnz-4ZY68PstexD9CxqGlCChUwaoNzJG/s320/sum+same+color+cell.jpg" width="320"></a></div> Sum same Color&#39;s cell contain number in Ms Excel.Several time we face color cell sum ,so I include here first Vb function than this function use for sum . Find details . Enjoy it!<br> <a href="http://shaifulaueo.blogspot.com/2012/04/sum-same-colors-cell-contain-number-in.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com1tag:blogger.com,1999:blog-2406697056813799036.post-82593257602800089712012-04-25T11:31:00.000+06:002012-11-15T23:37:09.381+06:00<div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgllYij_RXz0_xLyWLlDfDUvhKmnUHA8jHBnWAQbpmhP9b_je8LbCBSr5t40A_zd-QhGHm_bNBk6kq8-qFPpDP9gR_3HO70mhPgTTymSFG7K9rXH1ktjn1cPGQzOCMTa1rCST4pilW7lmhf/s1600/Duplicate+data+prevent.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Duplicate data prevent." border="0" height="192" img="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgllYij_RXz0_xLyWLlDfDUvhKmnUHA8jHBnWAQbpmhP9b_je8LbCBSr5t40A_zd-QhGHm_bNBk6kq8-qFPpDP9gR_3HO70mhPgTTymSFG7K9rXH1ktjn1cPGQzOCMTa1rCST4pilW7lmhf/s320/Duplicate+data+prevent.jpg" width="320"></a></div> <div class="separator" style="clear: both; text-align: left;"> Different time we face a problem duplicate data . So, I Publish this ,Duplicate data prevent by data validation .In data validation use a function and see magic.</div> <a href="http://shaifulaueo.blogspot.com/2012/04/duplicate-data-prevent-by-data.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-1671695941844972182012-04-18T23:51:00.000+06:002012-11-15T23:42:49.764+06:00<div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCBrA5-txH6AaXvTd34qRH4seeKfaSZ5ZGcsW_EVJ6jXxQ8QrK03bB7-1vAnIcVtSNeK9YwhvAE_L4lvNFVBT0sHpipuJcGqslc6ND8ajtFo3vzW-5CieYOo0wgZ9fJnEtATFZZ3YkoPTY/s1600/Copy+cut+pop+up+disable.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Copy cut disable." border="0" height="192" img="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCBrA5-txH6AaXvTd34qRH4seeKfaSZ5ZGcsW_EVJ6jXxQ8QrK03bB7-1vAnIcVtSNeK9YwhvAE_L4lvNFVBT0sHpipuJcGqslc6ND8ajtFo3vzW-5CieYOo0wgZ9fJnEtATFZZ3YkoPTY/s320/Copy+cut+pop+up+disable.jpg" width="320"></a></div> Copy ,Cut, Right click pop up Disable by VB in Ms Excel very easy way . At first Copy the VB code than paste your workbook , work start and save your valuable data from cut,copy.<br> <a href="http://shaifulaueo.blogspot.com/2012/04/copy-cut-right-click-pop-up-disable-by.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-3542761788939475812012-04-07T22:13:00.002+06:002012-11-15T23:45:23.726+06:00<div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7IF1NHn9AfjBo9HpHMzv4odfrimBQY8k2fDPmxO7zlYto1xF2njU9HJfbKuUpEpZLKeEy4-Z8NYghZHfzpPwo6_0OuozSWZSCoqaIf0dxp3QReWBjwQYH3Kw8z_DpckZ-BrFu7HpiejWH/s1600/Nth+small+and+large.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Nth Large Nth Samll data."img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7IF1NHn9AfjBo9HpHMzv4odfrimBQY8k2fDPmxO7zlYto1xF2njU9HJfbKuUpEpZLKeEy4-Z8NYghZHfzpPwo6_0OuozSWZSCoqaIf0dxp3QReWBjwQYH3Kw8z_DpckZ-BrFu7HpiejWH/s320/Nth+small+and+large.jpg" width="320"></a></div> Nth Large and Nth Small data find by function . Easy way find larger,smaller and largest,smallest data by this function.<br> <a href="http://shaifulaueo.blogspot.com/2012/04/nth-large-and-nth-small-data-find-by.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-69245474596077023622012-03-22T23:15:00.000+06:002012-11-15T23:50:20.263+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja0HPOzun8MMqs4vuN7c2KIbzWAJ_Ps_ytsLnVba05kA8MUf3rjLQLN9RE5wZsxtMZv0g88PGs9gmtqsT-0nIqzs8QuBwYt45CGosIMhDfsxkBDng0uA57c8t-P4hFiLL24HkKSX3BFLIk/s1600/sheet+index.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="sheet index."img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja0HPOzun8MMqs4vuN7c2KIbzWAJ_Ps_ytsLnVba05kA8MUf3rjLQLN9RE5wZsxtMZv0g88PGs9gmtqsT-0nIqzs8QuBwYt45CGosIMhDfsxkBDng0uA57c8t-P4hFiLL24HkKSX3BFLIk/s320/sheet+index.jpg" width="320"></a></div> Sheet index is very nice ,helpful and time saving thing. when you any sheet insert this sheet auto insert index .In index specific sheet click go to specific sheet, again back to index click return in index fully this create by VB code .you use this and enjoy .<br> <a href="http://shaifulaueo.blogspot.com/2012/03/sheet-index-create-by-vb-in-ms-excel.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-82654657100248181942012-03-10T11:47:00.000+06:002012-11-15T23:54:13.008+06:00<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyvwdeqzyNh5Wfen06mhu3CPuPgJODTLaguwg50tF9DrO8SUPEForeXhpru31jqB7tmmZoJjEJCllHzN43BPdDJbe7XiZDqG7bC4M2FFjpn2fGh78eFh524Jf6TI30aAJZ00Gr9tOulqZa/s1600/Combine+cell+data.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Combine cell pic."img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyvwdeqzyNh5Wfen06mhu3CPuPgJODTLaguwg50tF9DrO8SUPEForeXhpru31jqB7tmmZoJjEJCllHzN43BPdDJbe7XiZDqG7bC4M2FFjpn2fGh78eFh524Jf6TI30aAJZ00Gr9tOulqZa/s320/Combine+cell+data.jpg" width="320"></a></div> Combine two or more cell data in one cell by function . This method save time and easy to Combine , use this function and enjoy .<br> <a href="http://shaifulaueo.blogspot.com/2012/03/combine-two-or-more-cell-data-in-one.html#more">Read more/Download »</a>Md Shaiful islam Talukderhttp://www.blogger.com/profile/14257711496173285001noreply@blogger.com0