In column A , I have some cells with content , some blank.
In column B , all the cells have content.
I need to transfer the content of the cells in column B to column A ,
BUT ONLY to the cells in column A which are blank.

my question is " how i can protect a spacific area of a worksheet? either few
cells, rows or few coloumns?

not sure on how to do this, got 2 columns first has a dollar value, second
has the formula, the dollar value has both pos and neg value, based on what
value is in will return a word,
so +/- 1-500=tl +/-501-2000=ss and so on

Suppose that I have a sheet with a list of staff as follows:
                 A             B            C              D          
        1      Name      Age    Work.Yrs      Staff Level
        2     Mr.A          30          3              ?

I have a range of cells from E7 to E84
The contents of cells are variety Percentages.
What I want to do is using Count IF function to a count the percentages as
follows:

I have a resource spreadsheet that I'd like to automate as much as possible.
In Column "C" I have the supplier the column "E" I have the res rate, column
"F" I have the supplier rate and column "G" I have the charge rate.
Now based on the supplier there is a % mark up and when I do ...

I am trying to get a value in excel where the criteria that has to be
satisfied are text in nature, but I do not what to type the text in the
formula but the cell reference.
I have use Sumif, If & And but no joy.

I'm trying to do a vlookup with a couple conditions, and I can't figure it
out.  I'm sure the formula is relatively simple, I just can't figure out the
right language to use.  Here is what my data looks like:
Sheet 1

When I insert a Worksheet it is giving me a complete reversal of my
spreadsheet - moving column A to right side of screen in my new worksheet
whilst retaining remaining Worksheets with column A to left of the screen.  
How do I ensure this ceases?

Can you please help me to find out the total coloured cell counts from a
range of cells in any column ?
Thank you!

I have a range of cells from E7 to E84
The contents of cells are variety Percentages.
What I want to do is using Count IF function to a count the percentages as
follows:

if a cell is fill up with text it is consider one count. what is the formula
to use?

I have four columns of data and these cells will all have unique entrys from
A1 to L20. However, this information may change round so that some times not
all the possible entries will be used.  From this information then, I'd like
to create an IF statement that identifies whether ...

How to generate 2 random numbers at the same time whose difference lies in a
given range.
For example,
generate  a set of 2 random numbers a,b such that  .45 <= (b-a) < = .60

I have created a Pivot Table and where there is no data for that column I
would like to replace the (blank) with a comment etc.   I know if you sum a
column etc you can put something in for empty cells.  I do not want to hide
the row as there is a Property Name that is required ...