Excel VBA Tips: Running macros using hyperlinks At work today I had to create a workbook that provided links between different sheets within a workbook and turned on a filter. However, I didn’t want to use buttons, as it would be become extremely cluttered. I discovered that you can run macros using hyperlinks, so commandbuttons…
Read More
Excel Worksheet Tips: Table from PDF to Excel At work today, I was asked if there was a way to extract the data from a table in a PDF in Adobe Reader and paste it into an excel workbook. You can, if you have the expensive adobe acrobat version; however, for the rest of us,…
Read MoreWriting Tips – Mind Maps: Environment An important part of any story is the environment that it is constructed in. Without a set environment, the reader will not feel as if they are contained within the story; which will lead to them being disconnected. Ensuring that the reader is connected to your story is the…
Read More
Excel Worksheet Tips: Creating Navigation Buttons In a previous excel post, I explained how to create hyperlinks. Extending from this, you can link this ability with some simple VBA to create navigation buttons, similar to ones that you would find on websites. 1. Firstly, click on the developer tab. 2. Click on the “Insert” icon.…
Read MoreWriting Tips – Mind Maps: Plot The plot is one of the four major pillars of a story. The plot is the evolvement of the story, the unfolding of the journey that your main protagonist(s) embark upon. The question is, what makes a good plot? What aspects do you need to cover to ensure that…
Read More
Mac Tips – Speed up a slow Mac One thing that is always quite easy to diagnose in a Windows based computer is when the system begins to run slow, it’s usually a simple task to determine what has gone wrong. With a Mac, it’s not that simple. With Apple wanting to keep the MacOS…
Read More
Writing Tips: Spot the Difference (9): The Grammar Nazi I was looking at some of the searches on google that have brought visitors to my blog and I wanted to see if those searches were actually finding my blog. After putting in one of the searches, I came across a site which I find pretty…
Read More
Excel VBA Tips: Introduction Within excel, there are two sides to the program. The “front end” is the worksheet area where data is entered and the “back end” is the visual basic editor side. There are many different things that excel can do to help save time and allow you to become more productive. Why…
Read More
Excel Worksheet Tips: Hyperlinks When you have multiple sources of data and you wish to reference them all in one worksheet, it can get a bit messy to put all the data on one worksheet. Maybe you want to link to a web page? No problem! Creating hyperlinks in excel 1. Create some text which…
Read More
Mac Tips – Ctrl + Alt + Del on Mac There are times when you are using a program and all of a sudden it hangs and stops responding! After pressing: the left mouse button, the right mouse button, the spacebar, the enter key, the escape key and the backspace key, you realise that the…
Read More
SUBMEG 