I have 2 workbooks with series of numeric data (i.e A1 to A100 in both
workbooks), I want to generate automatic Sum of these data in another
workbook (Cell by Cell), which linked to Workbook-1 & 2. pls tell me the
formula for that.

My spread sheet  has a column of hyperlinks. About 100 of them.  They
are jobs I've applied for from the job sites.  Is there a way I can
search through the hyperlinks to count how many are from one specific
job board like "monster.com"?

I am a network tech upgrading folks to Office 2007 from Office 2003.  We
have found that when opening  Excel 2003 in Excel 2007, links are broken that
are deepy imbeded in the spreadsheets.
Have any of you encountered this, and is there a fix?   I am not an Excel

I have a task which seems relatively easy at first.  I have two dates
as inputs: a start date and a stop date that can vary between dates
and lenght of time. I have a header row with dates by month. I am
trying to write a formula that will tell me how many days between the

I have an Excel worksheet containing 4 worksheets. The main data is in
Sheet 1. I need to update certain cells in Sheet 1 regularly and those
cells are repeated in sheets 2,3,and 4. My question is can I update the
whole lot automatically to save having to open each worksheet every

Is it possible to launch an external application with its switches, from
within a "=HYPERLINK"? Something link this;
=HYPERLINK("C:\Program Files\Prog\Prog.exe" & " Switch1 Switch2 " &
Range(C6))?