software

How to get just file name on a cell without .xls extenion ?

Hi All,

Hi!
I have a macro that switches pages in a pivot table, which works as long as

I have a master workbook that tracks all projects for my firm (tabs are
Active, Closed, New). I email each project manager (approx. 16) their

I want to construct a worksheet that is based on invoices. A row should
represent an invoice and caontain invoice date, a brief description of the

Hi,
I have a simple IF statement that is =IF(A1gt;A2,A1,A2). The cell A1 is a

I've got another software program that will be filling a cell in Excel based
on a multi-select drop-down list. The Excel cell could read

I can't seem to operate the Range Finder function, in Excel 2000. When I
double click a cell (containing a formula), the renge is highlighted, but I

I have a workbook that has several data queries to external datasources. I
can either choose the Refresh Data action/button or configure my Data Qurey

if i get a conflict situation in a shared workbook, is it possible to see
what the conflicting situation is?