|
|
Protection by
BenJAMMIN
I have setup a workbook and selected certain cells to be protected. After creating a password protection for the workbook I saved it and turned it loose to the...
|
|
1 |
190 |
|
|
|
|
1 |
258 |
|
|
excel spreadsheet by
[email protected]
I have a 2 sheet excel spread sheet that I put together
with varing column widths.
On the top 1/4 of the first sheet (of the 2 part spread
sheet) I need to...
|
|
0 |
188 |
|
|
sumif problem by
saziz
Hi Guys,
I am using SUMIF(B1,"0") to find out negative values in column A1.
Now how can I say if the value in column A1is 1 bring that value to
column...
|
July 28th, 2004 05:00 PM
by saziz
|
7 |
270 |
|
|
|
|
1 |
440 |
|
|
Joining/appending two columns of data by
Richard Edwards
I have two columns of data. For example; one with a list of people in the IT
department and the other a list of people in the whole company.
I am after a way...
|
July 28th, 2004 03:54 PM
by BrianB
|
4 |
247 |
|
|
go back in pivot tables by
Abel
when you go back to previously created pivot tables, it won’t let you do anything to it (change fields, go to layout) apart from allowing you to trace it...
|
July 28th, 2004 03:40 PM
by BrianB
|
1 |
574 |
|
|
Pivot Tables from imported external data by
jjj
Hi,
I have a macro which refreshes 5 pivot tables, one after another.
However, when a pivot tables data changes slightly, a message
appears.."The refresh data...
|
July 28th, 2004 03:37 PM
by BrianB
|
1 |
536 |
|
|
Link Excel to Access by
Reggie
I am needing to populate an excel spreadsheet with data
that is in an Access file. The problem is that the Access
records are 779,834 and the Excel spreadsheet...
|
July 28th, 2004 03:25 PM
by Vaughan
|
2 |
399 |
|
|
excel question by
[email protected]
This is very strange - I have a worksheet with several
pages. Any of the pages that I choose - results in the
same problem.
As soon as I click on a field or...
|
July 28th, 2004 02:22 PM
by
|
1 |
181 |
|
|
Changing cell location with a formula by
woknick
How can change the cell locations within a formula. Here is my formula
=SQRT((B8-B7)^2+(C8-C7)^2)
I want to be able to substitute user inputs for the...
|
July 28th, 2004 02:11 PM
by Vaughan
|
2 |
345 |
|
|
|
|
1 |
171 |
|
|
Continuing a list with text and numbers by
Kevthewev.
I want to fill a column with image ID numbers followed by a suffix ie, "001.jpg" without the speech marks, and have Excel continue the list down the column,...
|
|
4 |
476 |
|
|
email by rows by
DaleL
hello All:
I'm looking for a macro that will go down a sheet and look for the
email address and mail every thing in that row to *ONLY* that person no
matter...
( 1 2 3)
|
|
24 |
599 |
|
|
Taskbar group close by
bigt
On the taskbar when I have a stacked group of files with
Word, Outlook, IE6, etc., I can right click and
select "Close Group" to close all files. In Excel,...
|
July 28th, 2004 06:54 AM
by bigt
|
0 |
182 |
|
|
Set of numbers by
Antonio
Hi all
Need your help, once again, if possible.
1 - On each set of numbers, how can i count the ones that are odd.
2 - Is there any way in a column, to know...
|
|
3 |
214 |
|
|
Echo Back the Cell Location by
Davey Boy
Is there a VBA routine that will echo back the cell
location based on the value in another cell ? For
example, consider the following
A B C ...
|
|
1 |
212 |
|
|
Excel 2002 on a Terminal Server 2003 by
AJD
My users have an issue in Microsoft Excel 2002 while
connected to a Terminal Server 2003. About 80% of the
time when they copy and paste in a spreadsheet they...
|
|
4 |
553 |
|
|
|
|
6 |
259 |
|
|
XL2003 Validation Input Msg Problem by
Phil
Hi... I need help with the Input message for a cell with data validation (when the Office Assistant is hidden).
In XL2003 the input message normally follows...
|
|
3 |
786 |