Is there a way of automaticly hidind or showing a worksheet. I have about 12 sheets on 3 different subjects and would like to show the sheets only that I want...

How do I get the the last two zeros to appear in cell i.e 10.00

I am running a macro that take a few minutes. Half way through I get a box saving do you want to save the file whith the normal 'Skip, Cancel' options. How...

Is it possible to set up individual sheets to print without the text boxes included? We have instructions that we would like not to print.

Hi there I am creating and expense report and I have included a drop list with currencies but I would like to convert automatically a currency different than...

I use a spreadsheet to keep track of some of the work I do. I insert pictures related to each issue as attachments (I only want to display the icon in the...

Basically I am wondering how I can get excel macros to call access macros or vice versa. Specifically I am looking for a way to have a macro built that can...

Hi all, I have some data which has been imported into Excel and is thus not laid out in the best way. So what I get is Customer number in A1, Customer name...

I am trying to convert some spreadsheets from Corel Quattro Pro (version 8) to Microsoft Excel 2003. We had no problem bring in word processing files...

How do you write a macro to activate Cell(r,3) when the current active cell is any other cell within the same row? How do you set the value of r to that of the...

i double-click on a document and will not open unless i open from inside the program.Microsoft excel does open but the file does not. When i open it from thr...

I am looking for a formula, that assiagn certain values for certain months. for example : i want to compare the date in Cell B4, if it falls in certain months...

I am trying to create sometype of template to pull data associated with a specific office. I have a drop down list create on WorksheetB. I have another...

Using Excel 02, WinXP, we were able to copy an Excel spreadsheet as an object into Word 02 (it had specific colors that they wanted to appear) but how can we...

I need to write a formula that will lookup a cell value in a table and return the value one cell above the look-up value. I.E. I would like to look-up...

I need to bring in data that exceeds the limit of 65,536 rows. Does anyone know how to expand this limitation?

Have a Dell laptop, XP pro, office 2003, all updates installed, and cannot copy between cells on a spreadsheet, between sheets in a workbook, or between sheets...

How do I format a cell to display measurement units with symbols in Excel 2000? (ie. " for inch, etc.) Thanks, Mandy

Can anyone help point me to references regarding building a single pivot table from multiple data sources. For example, If I have two different worksheets...

I have a drop down box in my file I use to look up customers, I would like to know how and if I can use the keyboard to jump to the customer by typing the...