I was just wondering if someone could help me with advanced macros.  I am
working in excel for departmental budgeting and have currently 8 - 10 budgets
set up at any given time for monitoring, but what i would like to do is
create a macro that will monitor all of the worksheets ...

I am trying to use the offset function to find a value and bring over bits of
information from the table the value represents.  My only problem is getting
the function to use the value inside a cell for the cell reference.  ie.      
              =offset(B29,5,1,1,1)    where ...

Have cells with First Last names in them - need last name only. How to delete
all characters up to and inlcuding the first blank space from left to right.
I am having difficulty because the length of the first name varies...

I have a spreadsheet with project managers assigned to different projects and
I need to assign each project manger and the respective row to a certain
color. the code I used is
Sub PROJ_MANAGER()

How can I calculate ages for example I have colums with ages and I need to
know how many people between of age of 20 to 30?

I have two non-contiguous ranges that contain individual letters.  I need a
formula that will count the number of occurrences of the letters P and L
within those ranges, let's call them B7:Q7 and B18:E18.  Can it be done with
one formula or do I have to count the ranges ...

I have multi-lined text data in source cells. There is a Y/N chart for that
data with an if-then "=IF('3. VPN Configuration'!C10="Y",'4. Environment IP
Addresses'!$B6," ")" which basically states if the cell = Y, then put cell
data on another sheet, which it does just fine. ...

Good day,
I don't know if this is possible in Excel, but I would like to change the
background color of a cell as soon as it has been typed in.  Is this even
possible?

Is there a way to use the SUMIF function with two conditions? For example, I
have a data table that has employee names, sales and commissions. I want to
sum commissions for a given employee when the commission value is greater
than X.

I would like to randomly sort the numbers 1-35 in my worksheet. Each integer
is in its own seperate cell, which are currently arranged in descending order
in cells A1:A35. I tried selecting A1:A35 and using =UniqRandInt(35) as an
array (from http://www.sulprobil ...

I am trying to find for example "(3)" in a column of 50 rows where each row
has a name in it.  The name for example may be "Jones" in row 1 and "Smith
(3)" in row 8.  The "(3)" means something to me in the database.  I need to
seperate each name that is marked by the "(3)" and ...

I am trying to use a if phase but my variable has the inches quotation in it
( " ). I think it doesn't recognize this. What can I do. I have to change to
many things if I was to take this out.
ex: =IF(("L_END_FIN@"="1/2"MAPLE_A3"),20.75,IF((L_END_FIN@"="1/2"MDF),6)).

Previously I shortened an excel spreadsheet so that only rows 1-199 show,
everything below row 199 is grey.
When I go in now to add a column, the sheet freezes on me and I have to shut
it down.

I need some help finding the max and the min values in a column using a value
from another column.  This is just a piece of the data, but the parts for
this question look like this:
Scan Date Time          Planetcode

i am using a search formula =(NOT(ISERROR(SEARCH(C$1,A2)))) which returns a
true or false answer.  I would like it to return answers of Available instead
of TRUE and out of stock for FALSE.  How would I change the formula to do
this?