You may think that an Excel Workbook already provides a table of data to you, and in a sense it does, an area consisting of Rows and Columns, with column and row headings and values.
It is, however, possible to create formal Tables from ranges of cells on an Excel worksheet.
Well, here are a few reasons:
In the following example we can see a drop list that a user can choose from when populating a Country column value.
When writing VBA, there are a number of occasions when you will have to select a single or group of worksheets. In this blog, we will explore some of the ways we can do this.
Selecting a single Worksheet
Selecting all Worksheets
Selecting the last sheet
Here are a few questions and answers about some keyboard shortcuts available in Microsoft Word.
The grep command is perfect in these situations and we explore some of it’s capabilities here.
While many organisations have moved over to “The Cloud” many are nervous of making the move with security being the number one concern. I came across a couple of interesting articles last week, which I thought I would share with you as they highlight some common IT security concerns among IT Security Managers and present some possible solutions to protect your company from common threats.
Although we can create Linked Tables in Access that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Access Query.
We will look at an example that enables us to lookup a customer’s total revenue value from an Access Query.
Although we can create External Data Sets in Excel that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Excel formula.
We will look at an example that enables us to lookup a customer’s total revenue value from an Excel Formula.
