|
|
referencing a cell in another worksheet by
Shannan
Hi,
I want cell F55 in worksheet "January" to display what is typed in cell B6
of worksheet "Sheet 1". These two worksheets are in the same workbook. I've...
|
December 22nd, 2009 07:00 PM
by Bob I
|
5 |
140 |
|
|
conditional formating by
Jim
Excel Users,
Thanks for the help. I would like to apply a conditional format to A1 if A2
meets a criteria.
For example if A2 is 100%, I would like A1 to...
|
December 22nd, 2009 06:49 PM
by Mike H
|
1 |
105 |
|
|
Find Average using Sumproduct by
Karthik
Is there a way to find average based on multiple conditions.
I've been using Sumproduct formula to Sum all the cells but not sure how to
use it find...
|
|
3 |
102 |
|
|
Navigational Learning Curve by
cwmagui
Why do I have to completely re-learn how to use Micro-Soft products every
time there is a new release? I have become quite proficient at using Excel
2003, but...
|
December 22nd, 2009 06:26 PM
by Bob I
|
7 |
160 |
|
|
cpu at 50% by
locochon2010
I have a spreadsheet with 130,000 rows, and vba macro running several loops
torugh it. The odd thing that I noticed is:
The CPU usage stops at 50%. I am...
|
December 22nd, 2009 06:19 PM
by Bob I
|
1 |
96 |
|
|
sorting cells by
Help with cell function[_2_]
when I try to sort a spreadsheet by certain columns, why does it mix
everything up?
|
|
4 |
167 |
|
|
Maintain hyperlink when moving excel files by
diestro
I am using Office 2003. I have a folder with a large number of Excel files
that all have hyperlinks to unique Word documents saved in another area of
the...
|
|
1 |
123 |
|
|
Still not working by
Jerry R[_2_]
I am trying to tally the life time hours of a piece of equipment taht the
hour meter has quiy working on. I know the hours on it when new meter was...
|
|
4 |
98 |
|
|
New Formula (Burt) by
Help with cell function[_2_]
This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if...
|
|
9 |
104 |
|
|
|
|
3 |
113 |
|
|
Merging from Excel to Word by
Barbara
When I merge dollar amounts from Excel to Word they come up with numbers like
$4,000.99999999999999999999. I would like them to come up with just places. ...
|
|
2 |
167 |
|
|
Unable to Unprotect a 2003 .xls file by
r25ramirez
My company recently upgraded to 2007. I had a file that was protected and
only certain cells could be modified, for data entry. I now need to
manipulate the...
|
|
4 |
110 |
|
|
Skip a Macro by
Vick
I have a worksheet_selection change macro, that I would like to skip if
another Macro is running, is that possible? Is it possible to tell if a macro
is...
|
|
2 |
131 |
|
|
|
|
5 |
152 |
|
|
|
|
3 |
111 |
|
|
Drag and drop data only?? by
Chanda
Hello,
I am working on a very large spreadsheet and need to drag and drop large
amounts of data. The problem is that when I do this is drags and drops my...
|
December 22nd, 2009 04:46 PM
by Chanda
|
2 |
99 |
|
|
|
|
4 |
94 |
|
|
How to show chart only? by
Eric
Does anyone have any suggestions on how to show chart only and hidden every
cells within this worksheet?
Thanks in advance for any suggestions
Eric
|
|
4 |
91 |
|
|
Array formula to Identify Leading Zeros. by
Commish[_2_]
I have a bunch of spreadsheets that have a sizable number of columns -
usually about 128 columns. And I need to identify those columns that
have leading zeros...
|
|
2 |
95 |
|
|
Extract the Sheet Name by
Vital_ar[_2_]
D/a,
Is there any option like a function or a macro to extract the sheet names in
a excel file.
For Example: I have a Excel file with 10 Sheets names...
|
|
3 |
101 |