Tag Archives: Macro

Input data on one worksheet… Get summary on another worksheet in #Excel

Posted on October 17, 2020 by MF

It is a common task that we want to input and maintain all data on one worksheet, and display summary on different worksheets. A typical layout will be similar to the screenshot shown above. One “Input” sheet, and then one … Continue reading →

Rate this:

Posted in Excel in Action | Tagged , , | Leave a comment

VBA to make selected sheets “Very Hidden” in #Excel

Posted on April 26, 2018 by MF

VBA to make selected sheets “Very Hidden”;  all sheets visible Weeks ago, I showed the way to unhide a very hidden sheet in #Excel via Visual Basic editor (VBE).  You may refer to that post HERE.  Technically we could follow … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment

Don’t Miss Out on the Early Bird Registration for Allen Wyatt’s Excel Macros for Beginners course

Posted on March 8, 2016 by MF

About a week ago I let you know about Allen Wyatt’s Excel Macros for Beginners course. At the time, I invited you to visit Allen’s overview for the course, and I told you that you could register for this excellent … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Want to learn Macro? Here’s the chance.

Posted on March 1, 2016 by MF

If you have been following my blog, you should know that I focus on tricks and tips of “preset” ways in Excel. For some people, using those preset ways is enough, but for others, Excel may be a bit restrictive … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment