i work for an accident management company and have a few new reports that
need some complex conditional formating i will details the requirements below
hopefully someone can help.
No Estimate Report:

I have a database table which imports data from the web.   This is OK,
however I need to be able to extract certain entries and copy them to a
different worksheet.
The advanced filter cannot do it.

I have grabbed a file where by entering an X in lets say line G7 on sheet 1,
it transfers all of line 7 (A through to F) onto the next available row on
sheet 2.  It doesnt explain how it is done though - any starting point for me?
I would like to use it for building a list from a ...

i would like to make a list of IP's going from 172.16.1.0-172.16.1.254, is
there a formula that will increment this to save me time? i need to type
about 3000+ addresses. please help..

Hi
I am having trouble creating a from in Excel.  In help it says to go to
File/New/open template but mine doesn't come up with a template option.  I
have put the disc in to to see if that helped but no - nothing!  Your help

I want to create a macro that will convert a number to Text format
so that it can be read by another formula where the cell needs to be text.
Below is the result of turning on the recorder and doing as follows (with my
cell that needs fixing selected before):

A friend of mine who is employed in a Christian Missionary organization
(non-profit and all that) needs to buy a copy of Excel to submit his expense
reports.  He's asked my advice about purchasing it.  I see that there's a
Home & Student version -- which on the surface doesn't ...

Hi, I have an Excel spreadsheet with a lot of text in each cell.  The text
looks fine on the screen but when it prints, some words have too much spacing
between the letters.  For instance, on screen a cell that has a sentence with
the following text:

the above question applies to office 2003 excel

Albertini, Oscar

I have Excel 2003.
I have a worksheet with 11 columns. I need to adjust the column width of
each column so that all data will be shown. I know that I can do this
adjustment by double clicking on each column's border, but that means 11

I am looking for a formula that does the following:  The word Area is listed
in some cells in the "A" column with the actual area number listed in the "C"
cell.  I want to tell the speadsheet that if the "A" column contains the word
area, then add the "C" column of that row.  Any ...

Hi! I would like to know how to figure out a problem.  Facts:
1) You have a long series of Year1 through Year x running across row 1
(starting in cell B1) in worksheet PROJECTS.  In column A. there is a long
list of project names (starting in cell A2).  In the area B2:Z99 there ...

I have a pivot table linked to an access file for it's data.  I would like to
send the pivot table out to other people, but they do not have permision to
see the data in the access data base.  I would still like to have the
functionality of the pivot table, but not link it to the ...

I have tracking numbers that have four similiar beginnings.  For each
tracking number there "should" be four steps attached to them.  I want to
create a formula or macro that tells me which tracking number does not have
all four steps on it.  Each row in Excel is the tracking ...