|
|
|
|
1 |
183 |
|
|
Spreadsheet with query statistics by
Jimbo
I have a query in an Excel 2007 spreadsheet and set it to automatically
refresh itself. I would like to have worksheet cells display information on
the last...
|
April 14th, 2010 06:39 PM
by Jimbo
|
0 |
169 |
|
|
Updating of a locked cell by
Julie12345
I have a worksheet protected because it is all formulas for calculations with
other worksheets within the workbook. When I change one of the unprotected...
|
|
1 |
159 |
|
|
|
|
4 |
126 |
|
|
|
|
1 |
168 |
|
|
Selecting only specific rows for a Sort by
mkflirting
We have meetings of 5 different Groups which monitor the incomplete actions
on the database that I have set up in excel. Periodically I need to print out...
|
|
1 |
126 |
|
|
|
|
0 |
124 |
|
|
Help with InputBox and MsgBox by
Preschool Mike[_2_]
How do I fix the below code so if a user does not enter anything in the input
box or clicks on the cancel button they get what I have in the MsgBox?
MsgBox...
|
|
9 |
149 |
|
|
Vlookup function... by
John Smith[_11_]
Sheet "Employee Data" holds usernames of about 1500 employees in the format
"joe.bloggs" in column A and employee payroll numbers in the format 00001,
00002,...
|
|
4 |
116 |
|
|
double use of Substitution Function by
Tonso
to eliminate spaces from a data validation phrase, I can enter "
=Indirect(substitute(M12," ","")" and find the named range i need
create a List.
But, suppose...
|
April 14th, 2010 05:50 PM
by Tonso
|
2 |
144 |
|
|
formula needed by
mothertucker
x is 80% of y and y is a portion of the total of z. How do you calculate z?
|
April 14th, 2010 05:15 PM
by Mike H
|
3 |
111 |
|
|
|
|
1 |
163 |
|
|
turning text into a calculated result: by
Wayne C
Hello all
I have a spreat sheet that looks something like this:
Cases Total cigarettes
13*10*20 2,600
13*10 130
12*10*20 2,400
with col A as...
|
|
3 |
205 |
|
|
Prevent Manual Calculation Mode by
Evan Weiner
Is there a way to prevent the manual calculation mode. It seems 2003 "knows"
when to set it. In most cases I find it annoying when results are obviously...
|
April 14th, 2010 05:07 PM
by Mike H
|
1 |
128 |
|
|
|
April 14th, 2010 05:05 PM
by Mike H
|
1 |
110 |
|
|
|
|
6 |
150 |
|
|
From Access to Excel by
Glenn_H
Good day to all.
After searching this and other forums, I am at a loss for how to transcribe
the following access formula to excel.
...
|
April 14th, 2010 04:54 PM
by Glenn_H
|
4 |
106 |
|
|
|
|
9 |
372 |
|
|
Merged Cells by
Danu
I have imported data into Excel. The left-hand column has merged cells
containing a reference number. The remaining columns contain varying records...
|
April 14th, 2010 04:41 PM
by Danu
|
0 |
109 |
|
|
Macro Help by
Dan Wood
My code is as follows:-
Sub SendEmail()
Dim Email As String, Subj As String
Dim Msg As String, URL As String
Email = Range("A5")
For Each c In...
|
|
3 |
114 |