I am importing a txt file with 168 fields.   I only want (for example) fields
4, 10, 35, 100, 135 and 160.  Can only these fields be imported into an excel
spreadsheet?

Sometimes when I return to an Excel workbook that's been open for a while, I
need to check it's path.  I've been doing a file...save as and looking there,
but I'm thinking there must be an easier way.  Is there something I'm missing?
Thanks,

is there a list somewhere of all the commands and their description?  i know
that you can drag a command up to the tool bar, drag the mouse pointer over
it and a description will appear, but this is time consuming as there are
many commands.  any suggestions?

I've run into a bug in Excel 2007 involving pie charts that is easily
reproduced.  Type in the numbers 80, 20 and 0.  Create a simple pie chart of
these numbers.  By default it should be a large blue segment with a smaller
red segment.  The green segment can't be seen since it is ...

the box with the FX shows "###" insted of the actual numbers, currency that
the total should be displayed. if i highlight it, he total shows in a
seperate window, but the box displays ###. is this a security feature
designed to ruin my day or what??

Hello again.
Experience level:
Good to Advanced in both Excel and VBA, i'm just stuck where to start!
I have 2 worksheets: Master Data and Supplier Data

Can anyone help me please.
I have a problem with the criteria part of sumif using cell values.
I can type a value into a criteria directly in for example 2007, and it
works.

I have to add every sixth value in a column summed over 52 value.  Is there
an equation to do this so I don't have to input each cell.
Example
Column    1     2     3    4    5    1   2   3    4   5

Is there a way to extract numbers from a cell? Basically I have a list of
APN numbers, sometimes they include letters but they are always broken with a
dash. I need to extract the three different sections of the APN number into 3
different cells. For example APN number:

If I use this in a template, how can I get it to save the correct day's date
each time?  Do I have to copy, paste special - values?

I'm relatively new to excel and am trying to put a spreadsheet together for
golf game results. I am trying to give a cell a value that represents the net
score for each player on each hole. Example: Hole #1 is a par 4 with a
handicap of 12, the player has a handicap of 25 and ...

Currently I am trying to send a mass email to about 2000 recipients. The
contact information was given to me in excell. I have figured out how to
import each contacts first name, last name, business address, and email into
my contacts in outlook as well as initiate a mail merge ...

I am trying to rank all values from two unequal lenth columns.   I need to
use the correction factor defined in user help as =[COUNT(ref) + 1 –
RANK(number, ref, 0) – RANK(number, ref, 1)]/2 so that tied values are ranked
appropriately.   My "number" value is each entry in each ...

How do I conditionally format cells within a column of a pivot table based on
their relationship with another value within the pivot table?  For example, I
want to format 2007 enrollment based on whether its up, down or the same as
2006 enrollment.  The pivot is set up with years ...

All:
I know this is not a solely excel question, it is more of a general
question, but  some of you out there might know the answer: I have a folder
with 100s of PDF files and i have an excel spread sheet sheet of a list of