Hello all, I’m trying to get Excel to grab data from a specific cell on an
external spreadsheet through a pastlink and populate that data to 2nd
spreadsheet that will be tag as a read-only document (for view purposes
only). The data in the first sheet will change when new lines ...

I have to folowing formula entered into an A___:E___ array:
=IF(OR('Division 2'!F1:F540=".",'Division 2'!F1:F540="c"),'Division
2'!A1:E540,"")
What I want it to do is carry over the A:E cells of any row where the column

I have a large File that I need to summarize.
On the Summarize tab I need to pull data from other tabs "2007-01", 2007-02,
etc...
There are several fields on each tab that I need to lookup and enter into

I need to get data from a closed workbook.  The problem is the name of
the workbook is variable according to what is in a date cell.
I have labeled my workbooks with dates in the format of:
yyyy-mm (eg. Feb. 2008 = 2008-02.xls)

I would like to set up an expression where if the today's date (listed in
column A) is greater than the dater listed in column B, the date in column A
bolds.
Help is appreciated!

I have =IF(B1>50,2,1) in cell A1  How an a get a blank value if B1 is blank
in A1

If the applicable beginning date cell is blank, I get the number 28232
result.  How do I get rid of it?

In need dates to change colour when they are out of date. I have a grid of
survey dates which i need to change colour / shade / flash when they expire.
I'm using the latest version of excel. Please please

I have a drop down list in B3 with three (text) values - call then a, b, and,
c.  Based on what a user selects in the drop down, I need to perform other
calculations:
If B3 = "a", I want to populate E3 with  0, or

##### is what it puts in the cell, anyone know why?

I have a strange problem and wanted to know if anyone had experienced the
same thing and what the solution is. I created a new spreadsheet and entered
all of my data. Some entries were supposed to be formatted as currency but
they do not show that way. When I check the properties ...

In Excel 2002 I have a workbook with 12 sheet. One ended up with > 45,000
rows. The scroll bar on this sheet is tiny compared to the other sheets. Is
there a way to set the lenght of the sheets to a specific number of rows.
Thanks

I am using Excel 2003 to work on a range of dates.  If the date is blank
(null) in a column, I need it to return a 1.  Also, in that same column, if
the date is between a date range (we are using a fiscal year from 7-1-xxxx to
6-30-xxxx), I need it to return a 1.   If the date in ...

I am using Excel ver. 2003. I create mechanical inspection reports and
am looking for a geometric dimensioning symbol library that can b
imported to excel
--

enter data in a cell from a list you specify with auto complete function