目前分類:title (3013)
- Aug 14 Mon 2006 20:09
Making a list inside a cell
- Aug 14 Mon 2006 20:09
Using Find amp; Replace to edit cell references in links
I built the following macro to edit cell references in links to an adjacent
page, and it works great- even though it must be updated daily. Basicly, it
- Aug 14 Mon 2006 20:09
Save External Link Values
Is this error specific to a version of Excel? Will this error go away if I
upgrade?
- Aug 14 Mon 2006 20:09
Update Macro: Leave Colour As Before Once Cell is Not Active
Hi therei got this Macro code, which makes the Active cell change colour, but the
problem is that once you move away from that cell it leaves that cell with no
- Aug 14 Mon 2006 20:09
column truncated due to width constrain
Hi,
when I want to save the excel file as the prn file in the condition: the
- Aug 14 Mon 2006 20:09
Need how-to or example for data consolidation
I have two similar worksheets that I am trying to consolidate based on the
column that represents the date. I just don't know how to use the feature or
- Aug 14 Mon 2006 20:09
Should be able to change name for a macro
Would like to be able to change the name of a macro in Excel 2003. This may
also be helpful in other Office products (if not already available...). When
- Aug 14 Mon 2006 20:09
Formula Partially Works, Please Help
I use this array formula to identify what price is used for a part number:
- Aug 14 Mon 2006 20:09
Need help finding non-duplicate email addresses...
Hi,
- Aug 14 Mon 2006 20:09
totalizer formula
- Aug 14 Mon 2006 20:09
Sort by calculated element i pivottable
I have a calculated element (unsure about the English term) in a pivottable
that I want to sort another element by. Is this possible? As it seems it is
- Aug 14 Mon 2006 20:09
refer to drop down item as a sheet reference in a formula
I want to use a drop down list of names to cause the formulas in excel to
look on a sheet in the same work book with the same tab name as the drop down
- Aug 14 Mon 2006 20:09
MS Word and Excel quot;save asquot; will not drill down
When I click quot;save asquot; and then try to select a folder, the hour glass
appears and nothing moves from that point. I have reloaded the software.
- Aug 14 Mon 2006 20:09
number sequence gap
I have three columns of info. Date, Check #, and $ amount.
I have a straight list in order of check#. There are several occurances
- Aug 14 Mon 2006 20:09
does anyone know how to expand the field on an axis
- Aug 14 Mon 2006 20:09
NETWORKINGDAYS
I am using NETWORKINGDAYS to find out the difference to when an item was
order and when it was actually received. When the order date is the same as
- Aug 14 Mon 2006 20:09
INDIRECT function do not work when other file is closed
- Aug 14 Mon 2006 20:09
Leap year date problem
- Aug 14 Mon 2006 20:09
Can you do an IF function whether a cell has a fill color of Rose
I want to get a 1 returned when I quere a cell if the fill color is Rose
(colorindex=38). Do you use the IF function or is there another way to do
- Aug 14 Mon 2006 20:09
How do I count differert items in a column only if the date in an.
I would like to be able to count the number of different iteams in one column
whose dates are less than 30 days older than the current date in another