January had a slow start as everyone was on holiday, but the new year picked up quickly, and everyone came out wanting new spreadsheet systems.

Most encouraging this month has been the huge increase in total visitors up almost 40% on last month. Can we sustain this increase ?

Well... if we continue to offer good content, don't spam people, and bring Excel and VBA jobs to people who need them, of course we can !

Going forward, we are particularly interested in large complex projects. If you know of any, please refer ExcelExperts.com.

read more

We all know how to sort rows, but did you also know that you can sort columns ?

Here's a screen shot of our data in Excel:

And here's what happens when we sort columns:

read more

• This is an excellent time saving tip to get screen shots from Excel into outlook
• Use Camera Tool

I have the Camera Tool added to my custom toolbar. See this tip for more info on how to customise your toolbar.

Once you have the camera tool on your toolbar:

read more

When I ask customers why they're not using Excel for more things, they often say to me: "Well, we'd like to do XXXX, but you can't do that in Excel can you ?"

Often, the answer is: "YES YOU CAN !"

So my question to all of you, is this:  What do you think can't be done in Excel ?

Nick

read more

There's no actual pre-defined Keyboard Shortcut To Open Excel, but you can set your own one up.

Here's how:

Go:  Start => All Programs => Microsoft Office

Then Right click on the Excel entry, and select Properties

read more

One of the most common use object is the Range object.

Normally, to refer a cell, we simply put the cell address into the range such as Range("A1"). Now, what is the simpliest way to refer to other cell like B1?

There are many ways to use the range object to refer to the cell from your starting cell. I find the simpliest way is the following: 

For example, if I want to refer to B1, I can simply write it as such:

Range("A1")(1,2).value or range("A1")(,2).value

This will return cell B1 value.

read more

ExcelExperts.com is pleased to announce a new section for jobs.

Recruiters looking for Excel / VBA experts will be posting jobs here.

Excel / VBA Recruiters:

read more

We've all been there happily developing our spreadsheet, and all of a sudden, the file size balloons.

Q: How did that happen ??!!

A: Most likely, it's uneven formatting that's causing the problem

read more

With advanced filter in Excel using menu while trying to find out Unique, the limitation is that the destination range should be on the same sheet as the source. However, using VBA there is no such limitation. Using VBA the source and destination ranges in Advanced filter need not be on the same sheet.

In VBA, to Copy Values from range A1:A5 to B1 you will generally write

Sheet1.Range("A1:A5").Copy

Sheet1.Range("B1").PasteSpecial xlPasteValues

Another method:

write the following function in the code window 

Sub CopyValues(rngSource As Range, rngTarget As Range)

    rngTarget.Resize(rngSource.Rows.Count, rngSource.Columns.Count).Value = rngSource.Value

End Sub

read more

Turning off autofilter using VBA is easy and quick, but you need to know how it's done.

Here's some code to toggle the autofilter on and off:

read more

Happy new year !

This year should be an exciting one with ExcelExperts.com making a big push for business.

The first large scale system is in production at a canadian company. They are very pleased so far, and have requested 2 more systems to compliment their sales operation.

We have taken on board feedback that the site was confusing and cluttered, and have changed the layout to be more intuitive.

read more

 - use: EVALUATE()

Here's a step through demo sub routine:

read more

  I tried to show all possible cases I know but found that there are much more.

These are some of it.

Hi all

This month has been very busy with ExcelExperts.com officially opening the doors to customers.

We have been swamped by requests for quotes, and it seems people realise that Excel is an increasingly popular business tool.

If you are a business using Excel, we guarantee that we can save you time and money with a little investment from you. Tell us your business processes, and we can advise on and implement changes.

We are looking for Excel Experts to join the team.

read more

Do you have a large amount of data held in an Excel Spreadsheet ?

• If so, you will be well aware how difficult it is to find things

This tip demonstrates a way using VBA that enables you to search through your data really quickly, and helps you to find what you are looking for.

What I have written is a demo I used for searching through flight details.

read more

Yep, that's right, ExcelExperts.com is looking for Excel Experts to get paid for Excel consultancy.

...but this is no ordinary interview.

To apply for this job, you need to prove the following:

1. You must be an Excel Expert, or be smart enough to learn quickly.
2. You need excellent communication skills. (Written more important than verbal)
3. You have to prove that you have the tenacity to see problems through to completion.

How do you prove this ?

read more