tag:blogger.com,1999:blog-3925071241912218898.post6629665178242515232..comments2023-03-24T00:31:52.948-07:00Comments on StockKevin: Excel Tip #1 - Copy/Paste Sum of Selected CellsStockKevinhttp://www.blogger.com/profile/02831501049012688377noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-3925071241912218898.post-20957827823625800272019-12-30T11:07:54.564-08:002019-12-30T11:07:54.564-08:00I've been looking for this for years -- thanks...I've been looking for this for years -- thanks -- works just as advertised!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-48521861661142824212017-07-18T00:01:43.456-07:002017-07-18T00:01:43.456-07:00Great, thank you!Great, thank you!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-71449286104087988502017-04-11T02:19:55.111-07:002017-04-11T02:19:55.111-07:00Thanks Superb !Thanks Superb !Anonymoushttps://www.blogger.com/profile/03729293029679093816noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-62077722767113463322017-02-21T02:37:18.049-08:002017-02-21T02:37:18.049-08:00I usually don't leave a comment on blog posts ...I usually don't leave a comment on blog posts that have proved useful, but I must say that you are a productivity genius!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-76196768394433243132016-12-08T09:31:58.778-08:002016-12-08T09:31:58.778-08:00That is a very useful post - thank you! That is a very useful post - thank you! timhttps://www.blogger.com/profile/04906879452541528334noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-77614630680665510962016-09-29T23:18:02.227-07:002016-09-29T23:18:02.227-07:00Oh my, this is brilliant!! Thank you so much for s...Oh my, this is brilliant!! Thank you so much for sharing!cuppop fhttps://www.blogger.com/profile/09923432824678361813noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-19325585382304469102016-09-13T06:54:34.946-07:002016-09-13T06:54:34.946-07:00Very nice!Very nice!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-74089386728700643122016-08-02T03:04:29.852-07:002016-08-02T03:04:29.852-07:00Ok I simply put average wherever you had put sum a...Ok I simply put average wherever you had put sum and it worked!!!!!!!!!!!!!!!<br />Thank you so much<br />Viccy Bakerhttps://www.blogger.com/profile/14402437172956403355noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-37353506352681313832016-08-02T02:52:48.789-07:002016-08-02T02:52:48.789-07:00Wonderful!!! But can you give us a way to copy and...Wonderful!!! But can you give us a way to copy and paste the AVERAGE of selected cells? <br />Viccy Bakerhttps://www.blogger.com/profile/14402437172956403355noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-10551611743556153172016-06-02T11:53:15.426-07:002016-06-02T11:53:15.426-07:00Thanks this is great!Thanks this is great!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-25554063642675790232015-11-24T01:19:33.639-08:002015-11-24T01:19:33.639-08:00Very cool. Just what I need. Thank you!Very cool. Just what I need. Thank you!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-74748041720317373732015-10-19T12:07:23.780-07:002015-10-19T12:07:23.780-07:00Thank you so much!! Just what i was looking for.Thank you so much!! Just what i was looking for.B.N. Waitehttps://www.blogger.com/profile/16978351676870770712noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-35442105925482026752015-10-01T16:07:01.799-07:002015-10-01T16:07:01.799-07:00Thank you so much!!Thank you so much!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-71511341909121829212015-09-30T00:34:54.884-07:002015-09-30T00:34:54.884-07:00Thanks for sharing your very helpful knowledge. Ze...Thanks for sharing your very helpful knowledge. ZeljkoAnonymoushttps://www.blogger.com/profile/09033663546108890816noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-40686660456897930572015-09-17T02:04:40.302-07:002015-09-17T02:04:40.302-07:00Incredibly helpful. Thanks for the very clear inst...Incredibly helpful. Thanks for the very clear instructions!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-2485093326908788732015-09-09T08:07:20.129-07:002015-09-09T08:07:20.129-07:00Thanks, Worked perfectly. Saved me hours!Thanks, Worked perfectly. Saved me hours!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-47077377304427443552015-07-24T08:38:44.884-07:002015-07-24T08:38:44.884-07:00Hi,
Best instruction ever, worked perfectly.
Than...Hi, <br />Best instruction ever, worked perfectly.<br />Thanks!<br /><br />Ari, Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-91792068891132353832015-06-28T20:39:24.117-07:002015-06-28T20:39:24.117-07:00Very helpful!
I also went searching for a way to...Very helpful! <br /><br />I also went searching for a way to copy the sum only of selected cells and found I put the following in, and it worked.<br /><br />MyDataObj.SetText Application.Sum(Selection.SpecialCells(xlCellTypeVisible))Kristan Knoreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-1646474928568466572015-06-04T00:07:54.611-07:002015-06-04T00:07:54.611-07:00Thanks for sharing the tip and explaining it so we...Thanks for sharing the tip and explaining it so well as well ;)Anonymoushttps://www.blogger.com/profile/14662787749561990156noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-53099739857416050572013-07-17T20:43:59.140-07:002013-07-17T20:43:59.140-07:00Hey thanks for the post - has saved me tons of tim...Hey thanks for the post - has saved me tons of time.<br /><br />BUT if you have a filter on your data that you want to sum, you need to change <br />"MyDataObj.SetText Application.Sum(Selection)"<br />to<br />"MyDataObj.SetText Application.Subtotal(9, Selection)"Anonymoushttps://www.blogger.com/profile/03979939167902444029noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-48085580097734805762013-04-16T01:34:52.791-07:002013-04-16T01:34:52.791-07:00Thanks kevin. From fellow auditor
Thanks kevin. From fellow auditor<br />Heinrich von Horstenhttps://www.blogger.com/profile/01565735863446639018noreply@blogger.comtag:blogger.com,1999:blog-3925071241912218898.post-66282376173890406272012-11-15T22:19:17.096-08:002012-11-15T22:19:17.096-08:00This solution was exactly what I was looking for! ...This solution was exactly what I was looking for! It was clearly written, easy to implement, and required no guess work on my part. Thanks for sharing your knowledge Kevin!<br /><br />-Justin G, MinneapolisJustinWebProhttps://www.blogger.com/profile/14597198355850353311noreply@blogger.com