How do I unlink a file that no longer requres a link that was used in the
development of a worksheet? The Link popup is always answered NO, but I would
like to eliminate this.
Tks

Perhaps this has been discussed in the past.
I have 30 worksheets in an EXCEL file.  The #1 worksheet is the main
informational sheet.  I'm trying to obtain the formula that would allow me to
retrieve a specific data from any of the given worksheet.

Hello I need a way of saving a workbook after I input something(a user
name) into a cell in column A. I have recorded a macro to save the
workbook I just need it to run when I update one of the cells. There is
a total of 22 worksheets I have to apply this to so f there is a quick

I posed this question a couple of years ago and someone helped by providing
a macro which I unfortunately lost.  I often create spreadsheets with prices
I copy from pricewatch.com.  I want to keep the product image but I want to
get rid of the buy now button.   I can't delete ...

Any advice on the following would be appreciated:
Using Excel 2003, am importing a table from MSAccess to Excel, 2 of the
Access field are Yes/No with -1 as the affirmative. When imported to excel
would like to be able to replace the -1's with a tick

Under autoformat, there is a variety of format to be choose, is it possible
to customize, e.g List1 color?  Formatting style doesnt work as the color of
each row cells occur at alternate row!

I have *=DATE(2006,1+1,0)* in cell A1, formatted as mmmm yyyy, which
appears as *January 2006*.  How can I have it appear as *JANUARY 2006*?
(I tried UPPER(DATE(2006,1+1,0)) but it didn't do it.)
Thanks,

This is exactly what i want, got off an earlier thread, however, don't know
how to get it to save in the folder "Problem vehicles".  It keeps saving in
My documents
Used the record macro to get this, but not sure where to place in codeing

I have an excel workbook with three sheets:
_FIRST_SHEET_
This sheet has three columns.  Column A is simply a set of random
numbers.  Column B is empty and is designed so that the spreadsheet

I need the number of items in a table that meet 2 conditions Parcing a
string for content and with a certain zip code.
I can't seem to get the syntax correct for the countif and the "and"
portion.

is there any way to remove all the links all at once? i copied a web
page with a list of over 300 names onto an excel sheet. now the sheet
has a hyper link for each name in that list. i can remove the links
individually but am wondering if there is an easier way.

Hi, I'm using an excel spreadsheet and I have a list of customer
numbers in column A and a list of account numbers in column B.  Many
customers have more than 1 account number.  What I would like to do is
change the layout so that I have each customer number listed only once

i am trying to keep track of the interest i am accruing on my c.d.  i am
keeping track of it on excel.  the only problem is i need to know how to
set up the calculations in excel.  i have 1500 in my c.d and the rate is
3.92% with a 4.0% apy.  the interest is accrued daily and ...

If there a way to do this:
I want to make a sheet that when I input a number it breaks out into to
cells, for example:
I input 1200 in to A1

have a small problem, I am trying to sort a spreadsheet, but need to
sort it by four columns. I'm sure I've seen this done before, but
can't for the life of me see where to set this...
Any help would be appreciated.