Past Tip of the Day
Good Monday Morning!
Since most of the MrExcel readers read the page at work, I'll start with an introduction here. I was reading the local newspaper and they had an article about the trendy, new, easy-to-use Weblog technology. Basically, it is easy to create a daily posting to your web site, without having to go through the hassles of FTP, etc.
It sounded interesting. On Saturday, I signed up with Blogger, and am now typing this article into my browser. With a click of the button, it will be added to the MrExcel site. I already answer a few e-mails every day, it should be easy to copy and paste them into the Weblog and create a daily Q&A from the MrExcel mailbag.
Sunday was a slow mail day, so here are a couple questions from Friday:
Ricardo asked is there a way to get the date and time automatically by creating a formula?
Carol asks "I have a column of numbers that I want to add. But I want subtotals for each person who may have more than one number. Is there a way to add each individual person's numbers without selecting each group for each person and manually adding.
For more details and an image about Data Subtotals, read method #4 in Tip 035.
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.