Does anyone have any suggestions on how to select item based on following
conditions?
Under column F, there is a list of numbers.
Under column G, there is a list of types.

We have developed a number of standard datasheets that we use on a daily
basis in our business. The datasheets contain, among other things, logos and
certification texts. We recently upgraded from Office 2000 to Office 2007,
and have encountered problems when copying the sheets ...

I am trying to write a contionalformat in code. I have this code ight now:
Range("E1:E10").Select
   Selection.FormatConditions.Delete
   Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlGreater, _

From Excel to Word 2003 I could copy and paste>special>enhanced metafile a
selection which included data cells and a drawing.
Now in Office 2007 the drawing jumps out of place, covering some of the
adjacent data cells.

A1=2/29/08,B1=ABC.=A1&B1.resulting in 39507abcab.how to get o/p as
2/29/2008abc in excel

I have several large files in notepad text format that I need to convert to
.xl in .csv format. (Windows xp) Can u help?

Howdy,
I'd like to know is there is a formula to counting the number of Employees I
have. Each cell though, has a formula in it, to display the name of the
Employee.

Whenever I put formulas to the right next to a pivot table, and refresh the
table, these formulas are sometimes overwritten due to the pivot table
extending with more information. Is there a way to prevent this and have
"floating" cells that moves as the pivot extends / retracts?

A bit of an odd one but is there a way to select all cells and make all text
capitals? I know there is a formula but I was hoping to do Ctrl A and then
turn all small case to capitals.
Any help greatly appreciated

I am sure I have seen this before but it is not showing up on Google.
A1 has a 5 digit number eg 12345
I want a formula or VBA code to produce
A2=1

Is is possible to hide/lock a tab in a spreadsheet so it can not be
opened/viewed without a password?
Thanks for your help.
Johnnie

Hi
Is there a shortcut in excel 2003 to copy the data from different tabs and
paste it on to one tab and making it a master data tab?
Is there a way to select all the tabs of the sheet and making it the rage

I have a vague memory that it is possible to add comments in the same cell
as a formula. (Not using Comment feature.) Does anyone know how to do that?
Rob

Problem: employees get paid different hourly rates at different times
of the day. From 00:00 to 08:00 is $NIGHTRATE, from 08:00 to 17:00 is
$DAYRATE, from 17:00 to 21:00 is $EVENINGRATE and from 21:00 to 24:00
is $NIGHTRATE again. As well as that there is an hourly surcharge of

Does anyone have any suggestions on how many sheets for Excell 2000 can be
created for a single worksheet?
Thanks in advance for any suggestions
Eric