How can I insert a ROW above a cell that contains data?
(Col A contains 985 cells but only 284 cells contain data).
In the following example, I want to insert another row above cells A3,
A5, A11 and A14.

How can I insert a row above a cell that contains data?
In the following example, I want to insert another row above cells A3,
A5, A11 and A14.
row          col A

I have a Sales Transaction worksheet which have column of dates of
particular sale.
I want to filter date e.g. 01.04.2008 to 30.04.2008
Column A

i have a list of names in column A15:A1014. The names will appear more than
once in the list. I want to filter this list into another column AQ15:AQ1014
so that only unique enteries are shown, but i want this as a formula rather
than using the advance filter option so that as the ...

I am setting up monthly worksheets in same workbook April 08 - March 09.
The data includes Staff extra hours and staff days off sick.
For the extra hours, I want each month to reference the total for last
month: I can do this manually (using [=]) but I would like a way of doing it

Is it possible to add text as part of the format, as well as changing the
Font/Cell colour.
At the moment the format is set to change the cell colour when 2 opposing
cells differ, but I need to show text as well as a colour change.

I have got a new computer and want to move macros in my Personal Macro
Workbook from my old computer - any help on how to do?
Steen

I need to add 30% to a whole column of prices, Is there any way that I can do
that besides going in and changing every number?

hi, have 5 columns of numbers that ascend in value from left to right,
if different col val is > highest value.. use next column to right as the
new goal level.
thanks

I have been supplied with multiple worksheets containing data that I would
like to pull together. New to Excel I'm not sure whether this can be easily
achieved, whether Vlookup is the correct function or a macro would be
required - any suggested solutions would be gratefully ...

How can I insert a ROW above a cell that contains data?  (In my
spreadsheet, COL A has 985 cells but only 284 cells contain data).
In the following example, I want to insert another ROW above cells A3,
A5, A11 and A14.

When I export to Excel the end of file marker should be at the end of
data but is set at the last row.  This causes significant delays when
deleting all the extra rows or when inserting columns.  How can I
prevent that from happening?

I am using Excel 200.
I have been trying to add Table of Contents (TOC) code to a spreasheet that
shows both a
subject field (generated by the same cell from each worksheet, not the tab

I have a list box in Book1.xls which references a named range in Book2.xls.
Book2.xls is ALWAYS open before Book1.xls. I set my list box reference in
Book1 as 'Book2.xls'!MyRange - which displays the data fine.
However, when I next open Book1, the list box reference automatically ...

I'm trying to find the advance sorting command in the ribbon. In the Help it
shows it appearing in Sort&Filter below the "Reapply" command but...it's not
there in my Excel!
Any clue?