Archive for the ‘Finding Data’ Category.

My own Euler problem

February 17, 2009, 6:20 am by jkpieterse

Hi everyone,
With all these Euler posts I thought, why not post my own?
Suppose the following:
I have a products table set up like this:
Code ProdName Price
0001 Product1 556.68
0002 Product2 977.41
0003 Product3 350.62
0004 Product4 509.16
0005 Product5 748.4
0006 Product6 802.96
(list goes on to as much as 5000 products)
And I want to show this table in a userform and give the user some filtering possibilities (lets say on the first two [...]

Category: Arrays, Automation, Columns and Rows, Finding Data, MVP, Miscellany, Sorting, Userforms and Controls, VBA  |  17 Comments

Two popular tools updated.

March 28, 2008, 1:03 pm by jkpieterse

Hi All,
As many of you know I give away a number of tools for Excel through my site www.jkp-ads.com. Today I have updated the two most popular downloads:
Name Manager (which I created together with Charles Williams, www.decisionmodels.com):
Most important change: the unused names filter now includes objects in its search, as well as VBA code. It [...]

Category: Add-ins, Downloads, Finding Data, Links, MVP, Miscellany, Names  |  11 Comments

Website update

January 07, 2007, 5:17 pm by Tushar Mehta

This post introduces several new items on the www.tushar-mehta.com website.

Category: Charting, Classes, Data Validation, Finding Data, MVP, Templates, Tutorials, Userforms and Controls, VBA Advanced, VBA Basics  |  6 Comments

Go Back!

February 04, 2005, 2:24 pm by jkpieterse

Hi all!
Being fed up with having to click and scroll up and down all the time when editing a large workbook I thought a little utility that enables you to jump back to where you where before would be nice.
Have a look at this little file:
Go Back
It has a toolbar that you can use to [...]

Category: Downloads, Finding Data, General  |  2 Comments