hi there everyone,
I'm hopeful that someone can help me with my excel problem. Here's my
dilemma: I'm trying to do a results table where results will come from a
worksheet that has different columns, one of which is a date column(let's

I wish to type in the cells 0100, 0200, 0300 etc  but cannot see the format
type that retains these numbers as four digits (allows me to go to 2400) .
Which format is it - I have tried several and it drops the first zero(0) off.
Cheers

I cant get the condA or condB to execute if value of A1 fall within range 1
to 10
if(and(A1 >= 1, A1 <= 10), condA, condB)
How to get the month with a increment value as below

Hello - Anyone familiar with a way to take an average of a range of
cells, but only for the cells that contain values.
So for example:
9

I have created a geographical map with different provinces in Excel 2003. I
have assigned a macro to each province and it works well.
I have also created a userform.
When the province textbox is prompting for input, I want the map to appear

This is probably simple to you guys, but I can't seem to get it to work. I
need a formula that will add together the sum of A1, A2, & A3 cells, then
display (in A4) 20% of the total?
Hope this makes sense.

How do I find a formula to get a year's salary

I want to create a pivot table using the pivot table wizzard from a worksheet
into a worksheet with the name table by running a macro. when I record the
macro I create the pivot table using the wizzard and it works fine but when I
try to run the macro again it errors "unable to ...

Can someone advise me how to insert more than 1 row a time.
Thanks,
Scott

From the ControlBox when clicking on the Exit Design Mode button, I
get a message:
The macros in this project are disabled.
This is preventing me from running my project.

I have read past posts on Pivot Table formatting and have achieved some
success with the formatting problem.  
My current problem is that on one spreadsheet I have used AutoFormat to get
the look I want for the Pivot Table.  On this table I expanded the width of

I have a Pivot Table in Excel 2007 with data. I have a Date column. I need
to filter the data so it shows me the data from 01-01-2008 and today date
minus 1 day. I would like to have the data filtered automatically (without
having to go everyday manually and change the filter ...

I have been tasked with putting together a pivot table for my group that will
highlight if a persons vacation falls within blackout dates. Right now I have
a list of names and a start and end date for there vacations. I also have a
list of blackout dates set up with start and end ...

Sir,
How to delete filtered Blanks Cells
Thanks
Hardeep kanwar

I have a workbook with 50 worksheets. And i want to combine 50 sheets
into one sheet
Is it possible?
If yes then how