Can any one help as to how you can permantly remove Macros in a work sheet. I have tried to egnore as per the drop down box but they still appear, when a...

When I try to copy just the visible cells after I have subtotaled, it pastes all the details even when I paste special (just values). SOmeone told me there...

Any idea why it say "Filter mode" instead of "X of Y records" in the bottom left hand corner after I've applied a filter? Thanks.

I have a column of dates that I need to sort through. At the moment I am using =COUNTIF(E8:E1000,"15/04/2005") to check dates that were before todays date....

I have two worksheets; One with the names (last, first) of last years employees, The second with the current employee list (last, first). I need to compare the...

The color gradient that looks like a sunset is available in the charts when they are added to a worksheet. I can't seem to find the same 'gradient' color...

I need to know how to calculate due dates automatically by enetering the date of invoice in one cell and correspondingly the due date should be...

I am trying to set up a code to change the cell color and font color depending on the entry in a particular cell. Example: If C2 is "John", then D2, E2, F2,...

I am using Excel 2002 in Windows XP Professional. While saving a file, I am always prompted to either "Save a copy" or "Overwrite changes". I find...

Part # ADP WC Part# ADP WC A 10 1 A ? ? B ...

thanks for that. i will try it and see what happens. cheers, kristy ...

Is it possible to do a VLOOKUP directly to an Access table instead of copying the data table into an Excel worksheet? If so can I reference the Access table...

I have Excel 2003 and would like to search (Ctrl+F)through all open sheets at one time. A coworker can do this. Is there a patch?

Is there a single command/formula to remove the first 3 letters in each of the fields in an entire column?

I am trying to create a formula in a spread sheet, but I can't seem to figure it out. I don't even know if its possible but I want to return a value in each...

I am attempting to create a simple quotation sheet I have one cell in Sheet1 validated as list: C1 - Customer Price-band Category (select from list) and...

I have a formula that I want to copy across different worksheets in a workbook but it keeps incrementing values that need to remain constant. The formula is as...

Hi, I am sure this has been discussed but I am having trouble understanding what is needed. I think I need to use a indirect call within...

I have a worksheet with contains macros. I want to protect the worksheet, but allow the macros to run. When I protect the worksheet, the macros are no longer...