....anyone cracked this simple one?
I have an Excel spreadsheet which contains a mailto hyperlink in one column,
& in two other columns on the same row I have text that I want to use to form
the mail subject - ie when the hyperlink mailto edit box is displayed, in the

I am trying to create a Price list, using Excel 2003, after importing data
from Sage Line 50. I have created a query in excel which works fine to start
with. The data imported is stock code, description, last cost price into
sheet 1. There is a filter that stops all discontinued ...

I want to use Excel for calculation of primes. Is there a way to have Excel
check if the result of a division is an integer (i.e. a whole number, nothing
after the comma) or not? E.g. if 7/3 is integer then display yes else display
no.

I have a macro that reads in, processes data & places it onto a presentation
worksheet. The following line allows ONLY the worksheet to be saved which is
what I want. My problem is that I get the 2 messages appearing & I want to
switch them off so that filing of the worksheet is ...

I use the following to test the last character in a cell.
=IF(RIGHT(E4,1)="A","Yes","No").
When I add more rows, I am always forgetting to copy the formula down.  is
there anyway that i can set up the worksheet so that I dont have to remember

=VLOOKUP(G284,AG1:AL6,MATCH(H284,AH1:AL1,0)+1,FALSE)
Is there anyway of copying this formula to multiple sheets with only the
cells G284 & H284 increasing by 1 each time - as AG1:AL6 & AH1:AL1 is a
reference to a data table.

Hi i have a column of indeterminant number of rows.  My total cell is in Row
2
Starting at Row 3 how do I express a formula that will sum the column
irrespective of how many rows are subsequently added?

Excel currently does not have the ability to conditionally format from a
function. When writing complex formulas regarding a range of data, it would
be nice to highlight cells as they are conditionally being selected by a
formula. This would be very helpful to validate formula ...

I have a spreadsheet which I require the numbers 1-300 to be green, 301-800
to be orange and anything 801 and in excess to be red.
The only way I seem to be able to do this is by establishing a sheet, which
I hide within my worksheet, listing consecutive numbers in 3 separate ...

What formula do I need to return a zero value in the re-order column when the
value is =0 or <0 i.e. a Negative value. This will eliminate the holding
stock and enable new items to be added.
Par Level        On Hand         Re Order

I am having a problem figuring out a macro to transpose 6500 rows of
name & address in clumps of 4 rows each in column A separated by 4
blank rows like this:
First and Last Name

I currently have one worksheet setup that contains a large inventory of
equipment.  I want to be able to setup another worksheet for users to input a
number (department code) and have it filter and copy the inventory from the
large inventory.  In other words, I only want them to ...

I have a client history that includes similar (Name, address) and dissimilar
(date) information. I want to extract duplicate records to another worksheet
and leave only 1 record per client on the other. Problem is querying only the
first 3 columns, LastName, FirstName & Address ...

I need to change the datas from top to bottom position or reverse the
position of dataset without doing the ascending or descending order of the
dataset.

I need to count the number of rows within one cell. Values have been input
using Alt+Enter to cut the data on separate rows.
If if helps, I could also count how often ".h" appears in the cell because
the data are C header files...