|
|
Hyperlink by
JJ
Can I use hyper link in one cell but link to more than one external data
files? If not, how can it be done?
|
|
1 |
172 |
|
|
|
|
3 |
182 |
|
|
CountIf 2 columns by
Phippsy
Hi
I need a formula to count cells in one column containing dates depending on
the contents of a differnt column like SumIf has the option
|
|
3 |
176 |
|
|
Pivot tables problem by
Amin
i just created a pivot table and he first row shows an empty row then the
second showed data in it why so any help.
|
|
1 |
210 |
|
|
|
|
1 |
183 |
|
|
|
|
1 |
232 |
|
|
blocked file format by
stan
I am using a procedure that saves password-protected a 2007 excel file to a
folder. when I try to open it I get the message:
"excel cannot open the file...
|
April 26th, 2010 02:49 PM
by stan
|
2 |
163 |
|
|
Invalid cell reference by
Grey Old Man[_2_]
I am writing an Excel 2002 template, and wish to convert a large range of
imported data.
All of my formulae have been written in row A on a ‘Reformatted...
|
|
1 |
196 |
|
|
|
April 26th, 2010 02:40 PM
by Sean
|
0 |
168 |
|
|
Turn on/off calculation in worksheet by
BJ&theBear
Can anyone please advise me how I would write a worksheet selection
event code so that when you select a particular worksheet it turns the
calculation on and...
|
|
4 |
254 |
|
|
|
|
0 |
167 |
|
|
shifting cells disabled. by
Menotti2
I am failing to drag or shift cells/rows/columns in my excel worksheet. I
have reinstalled MS office XP ,but it did not help me. What should I do?
|
April 26th, 2010 01:16 PM
by Mike H
|
2 |
201 |
|
|
Cell references in excel vba code by
Isis[_2_]
I have a lot of code in the form;
Sheet4.Range("S" & iCount).Value = Range("B20").Value
Sheet4.Range("T" & iCount).Value = Range("C20").Value
Sheet4.Range("U"...
|
|
4 |
227 |
|
|
|
|
0 |
240 |
|
|
|
April 26th, 2010 01:04 PM
by Louise
|
2 |
187 |
|
|
|
|
3 |
205 |
|
|
Find anomalies in a list of data by
sarahphonics
I have a table of values for 5 different geographical areas. I want a formula
that will look at 4 of the areas and compare it to the value of the 5th. If
any...
|
|
0 |
166 |
|
|
stop a macro from being used by
Ber
i need to be able to stop people using a macro twice on the same spreadsheet
untill another macro is used and then allow them to use the first one...
|
April 26th, 2010 10:13 AM
by Ber
|
3 |
183 |
|
|
|
April 26th, 2010 09:16 AM
by yh
|
0 |
214 |
|
|
Surety Template by
JJ
HI
Can somebody help me urgently. I am looking for a template concerning surety
as i cannot find anything on Office templates.
Tx.
|
April 26th, 2010 09:16 AM
by JJ
|
0 |
180 |