I am trying to nest sumif function with no luck.
I have a table of data with several columns.
I need to look at the month column first and see if it's "January", then
look at the "name" column to see if a specific person performed the

I need a macro to:
Copy the latest worksheet, (not a specific one each time)
Rename the worksheet to the contents of a cell (i.e. a date)
Any help with code?

.I want to set up a time sheet that uses straight time rate between 8am and
5pm on Monday thru Friday. Time and one half after 5pm on Monday thru Friday
and all day Satruday. double time on Sunday. Then it adds all the hours up
and multiplies the result by a dollar cost. The ...

I would like to colour code all the cells in my spreadsheet  based on whether
they contain a formula or not.
is this possible?

I am trying to have a program that will have 12 work sheets, Jan- Dec,
That I input a commision report on. I need to be able to take any
amount that has not been paid and copy that to the next month. I have
the 12 work sheets set up to show + numbers as owed and - numbers as

I have data validation set up for a few cells in my spreadsheet.  What
I am trying to do is create a secondary list based on the selection
from the first cell.
EXAMPLE.

i have two columns A & B filled with 10 rows of data.  I want to create
column C which should take values from columns A & B one below the other.  
i.e C1 should contain A1, C2 should contain B1, C3 should contain A2, C4
should contain B2,....C19 should contain A10 and C20 should ...

I am trying to search a partial text match given a range, in this case
three columns, and return a true false answer as to whether or not the
data can be found. Column A is a given users name and colums B, C, and
D are variations of names and logins from various programs. I am ...

I have aworksheet which I want to use in my stock tracking program.

Ver.  2003-SP2
I am using excel to extract data from Autocad Drawings.  Each Autocad
drawing exports its associated information into a seperate Excel File.  I
would like to be able to combine the data into a single file so that I could

I have two coloumns of numbers, (A&B).
Some numbers in B match the ones in A.
A has more numbers then B.
I need to insert lines into B to get them to line up with A.

Need a formula that will list a col of unique names based on multiple entries
of the same in col D. Using Advanced filter does not suit my needs.
               Col D            col G
5    NAME            UNIQUE LIST

Hello, my name is ATang.  I have put in the below codes in an excel file in
order to allow the users to select a company name in a particular cell, then
the respective logo will automatically pop up in another cell.  It works well
when the spreadsheet is NOT protected.  If the ...

I am trying to write a formula to add all totals for each month irrespective
of the year. So an August total and a September total in this case. Any
ideas???
30/08/2006    $70

Ok-I have a spreadsheet like this:
Vendor-Inv #-Date-Amt Due and a second tab with all the vendor info like
name, phone # & Fax #.  What formula can I use so that when I enter a vendor
name in the 1st tab it pulls the info I have from the 2nd tab and? And if