January 4th 2017

View this email online if it doesn't display correctly

Don't Forget To add [email protected] to your safe or contacts list to ensure you always receive your 3 FREE Excel Tips.

January 4 2017

Hello How

Welcome, and Happy New Year Excellers. I am excited to start another year of How To Excel At Excel and share even more tips and tricks to help you work smarter and faster with Excel in 2017.

I will be sharing just the one Excel Tip with you in this January 2017 edition,(let's ease ourselves back into things slowly?!), but first wanted to thank all my readers and subscribers for an awesome and very busy year.

I want to take the opportunity to share some facts and figures about the activities that have happened during 2016 at How To Excel At Excel.

Year Round Up 2016 for How To Excel At Excel

TRAFFIC - In 2016 we had 377,000 users versus 270,000 in 2015 that's an increase of 40%, as well as an increase in page views from 340,530 to 475,548 also a 40% increase also.

MACRO MONDAYS - I launched a new weekly blog post - Macro Mondays to share Excel VBA tips. So far I have shared 22 Macro Monday blogs, and you can find me on twitter with the hashtag #MacroMondays.

FORMULA FRIDAY - 52 Formula Friday Blog Posts were posted sharing formula tips and tricks for Excel. You can find me on twitter with the #FormulaFriday

HOW TO EXCEL AT EXCEL NEWSLETTER - the Newsletter went from every two weeks to every month. This was well received and thanks for your ongoing support in this change. In total 45 Excel tips were shared in the Newsletter in 2016.

January's Excel Tip

I have one Excel tip to share with you in this Newsletter and the usual 3x tips will resume on the 1st Wednesday of February 2017 as normal. I have decided to share one of the most popular tips on the website and the one question I am asked the most......

How To Create A Time Stamp In Excel?
A small piece of Excel VBA code can solve this.

We are assuming that the date time stamp will be entered into Column B (see screen shot below) on our worksheet, when an entry is made into Column A.

Open up your Excel worksheet and hit ALT +F11 to open the Visual Basic Editor. (if you need to enable the Developer Tab you can find out more here)
Double Click on the worksheet where your time stamp is to appear- in this example it is Sheet 1.
In the left hand drop down box select Worksheet and in the right drop down box select Change. (This will create a macro that runs when the worksheet changes), and the Value Target As Range means any cell we choose to apply this to.

We want to then type the following code underneath the First Line that Excel generated for us.

If Target.Column = 1 Then

Application.EnableEvents = False

Cells(Target.Row, 2).Value = Date + Time

Application.EnableEvents = True

End If

Let's talk through the code. It is an If Then Statement with the following meaning…..

If The Target Column 1 changes then we want the cells in the Target Row in the Second Column to change to the value of Date and Time. Easy huh?. Now we have a couple of extra lines of code in there, the Application.EnableEvents, by adding these in we ensure that the macro does not run on and on, by turning off the macro then turning it on as required.

This solution allows overwriting of previous entries, and will update with the latest date time stamp.

The result of this piece of code looks like on the screen shot below.

That's all there is to it. Just go ahead and test your code!.

I really hope you enjoyed this edition of the How To Excel At Excel Newsletter. If you have any tips you want to share with other Excellers just email me- barbara [at] howtoexcelatexcel [dot] com and I will share with newsletter readers.

Keep Excelling!!

BJohnston MSc,Bsc(Hons),MCP,MOS

Don't forget you can follow me on Twitter for even more Excel Tips and Updates.

The How To Excel At Excel Newsletter Is Available To Subscribers Only.

My records show that [email protected] subscribed to this newsletter.

If you have been forwarded this newsletter or you would like your own copy then send a blank email to me at the address above to subscribe or visit www.howtoexcelatexcel.com and hit Sign Up.

Barbara (at) howtoexcelatexcel (dot) com
Co.Kildare,
00447510677 418
Ireland

You may unsubscribe or change your contact details at any time.

What are AAA Games? A Deep Dive into …
Joel Leonardo manda cortar energia do…
Vous devez faire un chiffre dâ€™affai…
Exploring Opportunities with Freelanc…
Show hide objects with Excel VBA â€“ …

This post first appeared on How To Do It, please read the originial post: here