I have designed an Access database that holds  records relating to my stores
audit results going back for about 5 years plus a load more information
relating to these stores. This was used to produe a pack once a month,
however a change in senior management means that I have got ...

my xls file has almost 6 worksheet that have to keep switching between.
Is there a keyboard shortcut I can use to switch between worksheet
without using a mouse to click on the sheet I need to use
thanks

I am a new user of MS Office Excel 2003.  I know nothing about programming
language.  I already used the Help menu and couldn't find an answer.  I was
hoping to find among the menu choices a command that would let me replace
(what I think are called) worksheet column headers (A, ...

I have a cell that would like a calendar pop-up to select a date as opposed
to typing it in....is this possible (and easy)? Thanks!

I don't know if this can be done but I enter details of payments made
on three sheetst.
Sheets called 3A 3B and 3C the information on each sheet is different
but the payments received are the same so I enter the date and amount

I have simple spreadsheet for converting UK £s to Euro it is set up to put
the current rate into a box and it converts automatically from one to the
other from 50p to £100. I have sent this to a couple of people but they have
`excel viewer` rather than `office` so the programme ...

First off let me say that I know that this is not a Access Forum .. but
I have tried repeated to get my data into a Access table and it is not
working.. So this is what I am hoping to accomplish in Excel... Since
my knowledge of Excel far exceeds my knowledge of Access...

I have a csv file with zip codes (5 digit):
"asdf","asdf","53902"
Excel is DETERMINED to convert the zip code column to a number.  Of course
the problem is that certain zip codes have only 4 digits and Excel won't

Hi all,
Is there any method of code to select the first one in the list of data
in a dropdown list. Ie, suppose, there are 10 contents in the dropdown
of the filter. I do not need to select actual word, rather, i need a

what is the best way to leave a cell blank.
For example
Say in cell A1 I have a column of dates
In B1 I have a formula =A1+37 (days)

In columns A and B on my worksheet I input numbers from a printout.
If there are any 0 values on the printout for the data to be entered in
either column A or B, then the cell should be left empty rather than the 0
input.

I have a puzzling problem when using the IF function.  My spreadsheet
looks like this:
Date          Value          1             2            3             4
1/2006       100

I've got a validation list showing a project problem status: New,
Resolved, In Progress. These options are a named range 'Status'.
Thus I do Data>Validation>Allow:List>Source:=Status
No problem there. However, from time to time I need to input a custom

How to get a reverse filter list? I have a filtered by many complex filters
list. I want to get a list of items, which were filtered out by those
filters?
Excel version is 2003 sp2.

there is a summary source, i have 6 different sources. i want to lookup from
the summary source whether the 6 different sources exist in the summary? may
i know how to lookup multiple table arrays? thx.