I'm putting together a spreadsheet with revenue and gross profit numbers to
send out to my sales staff. My boss mentioned that he'd like a disclaimer on
the spreadsheet that the information is privileged, confidential and should
not be shared.

I'm not real experienced in entering functions and I want to pull into a cell
the week of the year and year. The data is coming from a cell like 1/9/2008.
I know how to create the week of year but I do not know how to add the year
and it to show up as 22008. Week 2 of 2008

Have a Lotus (remember that one) spreadsheet that uses lots of Dfunctions.  
Converting it to Lotus and need help with the Excel function.  Here's the
Lotus function in my FTE worksheet:
@DGET(MAP,"directorate",Activity=B6)

Hello and thanks ahead for your help. I have a row of data that is CF
to turn red when true. Then I would like to sort this row to put
uncolored cells to the bottom of the list. I have gone to Chip Pearsons
sorting CF Colors Page and have tried ColorOfCF and ColorIndexOfCF and

I have a spreadsheet of 3000 contact names
I am trying to assign these in the most "fair" fashion to account
resps.
My thought was to create a column called "account_rep"

These dropdown boxes were visible all the time.  Now they only appear when
the cursor is held over Home, Insert, etc.  What happened to the dropdown
boxes and how do I get them back?

I have a list of dates (consecutive weekdays - some holidays) in Column D in
Sheet2.  In sheet1, I have a reference to those days.  For example in A3 I
have the formula =Sheet2!D3 which displays the correct date.  I'd like to
copy the formula to every 7th cell in Column A in ...

I try to look for solution to automate using VLOOKUP to match the "part
number" and copy series data from another spreadsheet to working spreadsheet.
I have try the VLOOKUP and MATCH but only single value allow to copy.
Pls adv......chew

Is it possible to have numbers from a predetermined list, appear in a
specified cell at a specified time interval?
IE from a list in (A1:A30) containing numbers from 1-30, I would like a
random number to appear in F10 every 4 seconds.

Good morning --
I have a workbook storing similar data on multiple worksheets.  I have a
'Report' page, from which I'd like to abstract the right person's data onto a
jpeg form and print it out.  I'd like to be able to put the person's name in

If my formula is trying to multiply one empty field with another empty field
that is fine.
But if I am trying to multiply an empty field with another empty field that
has a formula in it (specifically a VLOOKUP)  I get a #VALUE error. How do I

I am trying to take a new list of people, and based on these people account
numbers, I need to display certain Text. For example-If Julies account number
is 12345, Then she is Marks guest, but if her account number is 54321, then a
field would display Lisas guest. I have a Fixed ...

Just installed 2007 and like it - would like to use conditional
formatting to highlight cells based on if the cells equal a group of
numbers - actually it is a worksheet containg all the office pool
powerball tickets so I want to go through the worksheet and highlight

I need to make a list with all the days of the year in it. It is very
cumbersome to enter every day manually. Is there a way to do it
automatically? Thank you!

I have an xcel spreadsheet that has merge cells button disabled. How do I
enable this button?