I have an excel workbook that consists of several sheets and 4 of these
sheets are charts, i am wondering if its possible to see where the source
cells are that drive the chart columns.
I know they are not external they are all within the workbook.

I have an excel file with about 20 sheets in it. To save time trying to
find the correct sheet needed I have a front sheet with macros to take
the user to the sheet they need to use. What I would like to know is
this? Can I put buttons on the page so that users can hit the relevant

Can a Microsoft Office Excel Chart Object be refreshed by linking it
to an excel spreadsheet?  The "chart object" is being copied from the
originating excel spreadsheet, using the special past function to make
an Excel Chart Object in a Word doc.

Looking for some help on how to use the analysis tool-solver and What If
Analysis
tool-goal seek.  
Kathy

This works:
Sheets("Schedule").Select
Range(Cells(25, 1), Cells(LastUsedRow, LastUsedCol)).ClearContents
this doesn't:

I currently have a spreadsheet set up to record staff holidays or sickness.
But i would like the column AG to total how many times the letter S appears
in any of 31 cells from colums B to AF.  Each cell may have either nothing
entered into it or S or H.  Thanks for any help

I have a spreadsheet that has some cells in a column containing both
text and numbers, i.e. a phone number, city and state. In that same
column I have cells that only contain a city and state. I need to come
up with a formula that will identify which cells do not contain

... is this possible?  What accommodations, if any, need to be made?
Thank you.

this is husnain from pakistan, i would like to know that what is Macros and
how to use it.
I m a new user and i just know the simple options like i can make simple
sheets using simple  formula i dont know that what are the logics for using

I am importing data from an Excel spreadsheet into a .Net DataTable
using the following code:
// conn string
Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended

Excel 2000
Do you know why the annoying "File Not Found" dialog box
shows up?
This sort of thing happens when I move a few of the work sheets out

I have searched this column for quite a while to find a relevant
solution  to my question but I still have not found it.
What I have is two lists.  One names SKU and the other Description
which is description of what the Item SKU is.

I am new to Excel and have Excel 2007 if that makes any difference.
I am just trying to write my own vehicle logbook for my own vehicle which is
used personally and for work. To denote this I have done the following:
value 1  value2  Notation  work column Personal column

Greetings -- I am a household user who has used Quattro Pro 7 since
1999  on Windows 98 -- only for household use. Will be upgrading to
VISTA sometime in the next few months and wonder if I should buy the
Microsoft package containing Excel or the Corel package containing

This should be simple...but it's beyond my knowledge.
I have column A (20 Drivers) Column B (position in race 1-20)
I want column C to show points won based on the cell contents in adjacent
cells in column B.