Tuesday, September 18, 2018
Home Tags Worksheet

Tag: worksheet

Move filtered rows from a table to another sheet

I built a table in excel where I am comparing items. Some of those items are things will require further action after analysis. I created a column in the table with a drop down menu for yes/no. If the item requires further analysis I select "yes".

Transfer most Recent Records

A macro developed to compare rows of data and then transfer unique rows from the source worksheet into a result worksheet. This can be applied across many different uses in other spreadsheets.

Shortcut to Last Worksheet used

The Excel Help Desk received the following request for help....Is it possible to define any shortcut (key sequence) in order to be able to quickly switch between last used sheets which are not next to each other - preferably using only left hand

Worksheet Custom Sort

For this problem we received a copy of the workbook. We then used a formula to extract the last two digits of the text string. From there we sorted the worksheet by the extracted digits to acheive the result. See the post for screen shots of the un-sorted list, the formula used and then sorted list.

Protecting Cell Data in Excel

After you have a developed an Excel spreadsheet that is going to be used by others you should consider protecting the spreadsheet to guard against any unplanned changes to formulas and formatting by less experienced users. Excel's Cell Protection feature can provide this functionality ensuring that critical formulas are not inadvertently changed when using the spreadsheet.

How to Unlock and UnProtect all Worksheets in a Workbook

In this post we provide a macro that can be used to automatically remove Worksheet Protection to single Worksheet, some Worksheets or all Worksheets in a Workbook. For this VBA procedure to work you will need to know the password that has been allocated to the worksheets.

How to Lock and Protect all Worksheets in a Workbook

In this post we provide a macro that can be used to automatically apply Worksheet Protection to single Worksheet, some Worksheets or all Worksheets in a Workbook. In future posts we will provide an macro that will Disable Worksheet Protection.

How to use Data Validation

Invalid and inconsistent data is one of most common problems in Spreadsheets. If the data supplied is not in the right format or is not entered consistently then any following formula's or calculations will either not work or worse still provide a result that is not correct. Excel provides a built-in Data Validation feature that can be included to any spreadsheet. Data Validation provides error checking and instructions for the user as they enter data to a spreadsheet. In this post we will demonstrate some simple examples of Data Validation on a customer address list.

How to print Worksheets to different Printers

The quickest and simplest way to solve this problem is by using a Visual Basic Macro. In this case we need to set specific commands to print Sheet A to one printer and then Sheet C to another printer and not printing Sheet B.

How to check a Worksheet Exists

The following simple macro will provide a quick and easy way to make sure a Worksheet exists in a Workbook before you start any changes or other processing on that worksheet. This can be a problem when working with large numbers of worksheets that are created during a macro process. If you try to create a worksheet name that already exists your macro will fail with the following debug message

LATEST

MOST VIEWED