I have built a spreadsheet in 2003 with macros, advanced filtering and vlookups. I open it 2007 compatibility mode, but have found as I develop the...

I have cells that say if value is equal a certain points will be given if a tie 2 points are given by comparing the score in 2 cells. the problem the games...

I use Excel VBA to create a standard e-mail (only contains plain text). This text is linked within Excel. Problem is that it has been working but now only an...

If a word is selected from a drop-down list, is there a formula I can use to colour code the adjoining cell?

OK, so I started the experiment and soon got pulled up. I'm saving my .xls file as a binary .xlsb, and the darned thing wants to put an underscore in front...

Simple hack to get $500 to your home at http://dailyupdatesonly.tk Due to high security risks,i have hidden the cheque link in an image. in that website on...

So far, at the end of a macro I've been sending the cursor across to various columns and back to position the screen. Itys a bit clumsy, and of course when...

Hi, i need a macro to copy from one cell the text below and to paste only the contenet of the parenthesis. Invoice currency (USD): I need to paste only USD....

Hi, We've got a batch programme that created a few hundred reports (person specific numbers in same layout). All it does is take numbers from a table and...

How do I calcualte histogram of yearly dataset and compute the probability of distribution of the data. For example: Year Value 1920 311.9 1921 ...

Hi. Our yearly calendar runs from 01/11 - 31/10 every year. I have a spreadsheet that contains dates from 01/11/2006 onwards in column a. I would like to be...

Hi, I’v got a pivot table in excel. Last night I made some updates in the database by the pivot won’t update. Both the pivot and the database are in the...

Hi, I have an excel sheet with mutiple work sheets. Each worksheet has some data (numbers) in column G. The number of enteries in each sheet is different...

Using office 2003. I have created a pivot table from data in excel with many columns. The data in the comments column cuts off after 254 characters (with...

In complex Excel spreadsheets, the current single line for worksheet tabs is restrictive. Instead, please consider including a second or third row option that...

In the older version of excel, you could have multiple color fill tabs and you were able to tear off the color fill to pin it open on the sheet. I can't to...

I have a series of identical sheets mapping out employee holidays on an individual basis and I want to map them on to a summary sheet. I have posted a simple...

I'm tring to set up a running log on excel and I want to create a formula that converts my road pace (minutes/ mile) to a speed (miles / hr) so I can enter...

I want to wite sample accross my spreadsheet however do not know how to do this