I have absolutely massive spreadsheets based on horseracing results.
Each selection (horse) has 5 columns of data and anything upto 30 rows each.
I have managed (with help) to collate the info so that at the break between
each selection there are 3 blank rows. What I would like to ...

This is what I'dd like to do
1000
1000
2000

I have the below Macro but would like it not to ask the user before
overwriting the file anyway to do this????
Sub AASAVETOSTICK()
' AASAVETOSTICK Macro

Greetings all,
oh hear me, practitioners of spreadsheetery, and heed my humble plea
for aid... I'm struggling with finding duplicates based on the values
in two columns. Basically, I've got people entering a list of IDs in

If I go into PivotTable Field Settings, then Advanced, there's an
option under AustSort Options for "Manual (you can drag items to
rearrange them)".  How does this work?  I can't see where I can drag &
drop items, it doesn't work on the spreadsheet & I can't see where

hello..
im looking for formula which will give me an output related to th
date.
heres what i am looking for.

Is there a way to duplicate programatically the "show desktop"
shortcut on the quick launch toolbar

Hi, I am using a COUNT combined with 2 IF functions, as shown...
{=COUNT(IF(Apr07!$I$10:$I$1001=VALUE("1/4/2007"),IF(Apr07!$J$10:$J$1001="Danielle",Apr07!$I$10:$I$1001)))}
To give you the overview, it's a spreadsheet for time recording emai
advice at where I work. The advisor will ...

I have a named Range that containts horizontal column headings on one
sheet and I want to have a list box (where users can just click the
column they desire) and then calculations adjust accordingly.  When I
insert the ListBox into my other sheet and select ListFillRange

Okay, I am sure I am an idiot, but I want to copy the value of another
cell, based on the value of my target cell.
Example:
Formual in Cell L1

When I perform this function, after (2007,3,5) the cell output is
"0".
I need for the information that is displayed on (2007,3,5) to be
permanent and not

i need a formula to count the occurence of the comma character (",") in a
single cell.  That's the easiest way I can think of to count dates that are
exported into a single excel file.  I know I could use the text to column
function and use "," as the delimiter and then count the ...

I am trying to write a macro which filters a table of data usin
criteria determined in another worksheet.
This is the code that I produced to date.  The variables Cruiseline
and cruiseline2 work fine however I want to be able to filter a dat

Ok so I know why its allways False :)
but.. still have problem with IIf
i can write
IIf(Replace(Sheet1.Cells(2,5),"X", "B"), "="& FJan, 0)

sheet1 - data -
date, field1, field2, field3, field4, field5
sheet 2 - filtered report -
C1. begin date  - if blank then till C2 if C2 is blank then all