Hello, I am trying to get a formula to read the following...I have come close
to getting the answer I need, but am not quite there yet! Any help would be
much appreciated
Coloumn A contains various locations in the UK, written like - England,

Dear Sir,
Lets consider the following worksheet:
      A             B               C                D
1  Product    Invoice     Amount     Sub Total

How do I create a range of rows dynamically based on a number in a given cell. For example
in $A$1  the value is 12.
In C4 the value is 1. What I want to do is create  more rows in column C based on the value in $A$1.  The values in column C
should be 1,2,3 etc. Any time I change ...

Usually all formulas start with an equal sign (=) Other characters too have
some special meaning in that when entered instead of the equals sign, Excel
entered the equals by its self and, sometimes, removes that character. For
example minus, plus, or @.

Help me interpret this formula:
=OFFSET(INDIRECT(ADDRESS(ROW(INDEX(F24:F27,MATCH(I5,F24:F27,0))),COLUMN(INDEX(F24:F27,MATCH(I5,F24:F27,0))))),,
1)
As far as I can tell, this returns the value one cell to the right of

Hi all, I'm using Excel under MS Vista (I think that's Excel 2007?)
and I want to set certain things when a file opens and closes like
sheet protections, hidden tabs, passwords. I've seen it done where a
series of macros are run as soon as the file opens or closes.  Can

Sometimes when if reference a value in another worksheet I get an absolute
value displayed.  For instance I would type = then go to the sheet where I
wanted to pull the information from, say a work sheet named "Oxen", select
the cell I want and hit the enter key.  What I get in ...

I have a spreadsheet with several columns. I want to create a report using
the information in the spreadsheet.
On of the columns is "Enrollment Date". It is formatted as XX/XX/XX
On my report page, I want to be able to type in a year such as "2004" and I

I have created a function to calculate how many weeks there are in between
two dates that are chosen through a fomula.  However where there is a date
that falls less than one week apart I get a #N/A error.  I need a function
that can substitute everytime theres a #N/A with a date ...

My work group have several people that use the same workbooks on a shared
server.
On some of these workbooks I'd like program a reminder about certain tasks
that need to be done when working with worksheets within the workbook.

I currently have a report that I export into Excel. The name of the Column is
Company Name. Sometimes the names are small and sometimes big. But the Column
Width always needs to stay at 50 characters wide. So if the name is only 10
characters wide, I still need the remaining 40 ...

The text in each of my spreadsheet rows appears too close to each other.  How
can I automatically put space between each row in a large spreadsheet.  Can
the horizontal gridlines be broadened?  I don't want to add blank rows
between data rows because of formatting and formula ...

Last night, my computer was upgraded to Windows XP. I found that macros I
had recorded were no longer visible. The one I used most often was rather
simple, so I just re-recorded it...it involves copying some data from a CSV
file into an Excel spreadsheet. Before the upgrade, it ...

How can I keep my macro from using a hard reference to a particular run of a
csv file that the macro exports into another worksheet?  Each time I run the
csv file (e.g. to tweak the macro, or just to test the macro to see if it's
working), the

I am trying to extract number (%) from a table using “lookup” however the
first column to be used is made up of a range versus merely sequential
numbers e.g. 0 >=70, >70<=80, >80<=90 and so on and then the row used is
similar e.g. 0 >= 300000, >300000 <=400000, >400000 <=500000 ...