|
|
Exce - Cursor Help by
ajw150
hi,
Is there any way of either hiding the cursor or restricting it to a few
cells? I have mastered the scroll area so the template wont move, but
the cursor...
|
|
1 |
137 |
|
|
Counting occurences on multiple criteria by
Ron H
I have a sheet of business data.
There are 3 locations of service and I want to count the numbers of
sales in each location over a given time period.
Column C...
|
|
3 |
259 |
|
|
'Save As' macro by
wendyh
I need to record a macro that allows me to save the workbook with another file name. I cannot stop the recorder with the 'Save As' window active. My workbook...
|
|
3 |
183 |
|
|
Removing VB Code!!! by
Adam
All,
At work because the email exchange blocks spreadsheets with VB macro's in them I need to remove the below code I have in one spreadsheet:
Private Sub...
|
|
3 |
519 |
|
|
Precision in Excel by
routeram
Hi,
I find this very puzzling.
I have 2 cells with the following values.
-2.53948423496706E+64 (say =t)
-4.04686094372251E+96 (say = m)
Now I have 2 other...
|
|
8 |
427 |
|
|
Lookup text with multiple search criteria by
analyst
I know how to look up data and text using vlookup and hlookup, what I'd
like to know is whether there is a way of looking up data based on more
than 1 search...
|
June 17th, 2004 01:38 PM
by Domenic
|
4 |
428 |
|
|
Excel Workbook Protection by
E Lane
I have protected my workbook and can't remember the
password. Is there any way to recall, or override the
protection?
|
|
1 |
145 |
|
|
Vlookup based on 2 criteria by
litos_aldovea
Ok, that was easy for you guys but.....
I have now another problem totally related to this matter.
I have 3 columns of data, NAME, DATE,TEXT
NAME Date ...
|
|
0 |
239 |
|
|
Rolling excel tables in powerpoint by
JRW101
Hi,
I'm trying to create a slideshow with one excel table rolling across
several slides.
The data will change and needs updating monthly; I want to be able...
|
June 17th, 2004 02:28 PM
by JRW101
|
0 |
360 |
|
|
IF & AND formula by
NCA
newbie question..
I have 5 cells (A2:E2) which have different percentages
the headers of these cells (A1:E1) have year-end date eg. 12/31/2004, 12/31/2005,...
|
June 17th, 2004 02:30 PM
by NCA
|
3 |
129 |
|
|
|
June 17th, 2004 03:12 PM
by Andy B
|
1 |
475 |
|
|
Two-column lookup help! by
EKnight
Greetings,
I am having difficulty looking up an item using two-column lookup
formulas as suggested. Following are the parameters of my situation
2 Different...
|
June 17th, 2004 03:37 PM
by Vaughan
|
1 |
132 |
|
|
transferring data from a shared workbook by
Joey
Hi all
I'm trying to create a spreadsheet that returns data from another
shared worksheet used by a number of colleagues.
Is it possible to have a formula...
|
June 17th, 2004 03:39 PM
by Joey
|
2 |
182 |
|
|
Names & Addresses by
Samantha
Hi
I have a list of names and addresses which are all listed
in column on vertically but I need to change it to
horizontally without having to retype all the...
|
|
4 |
138 |
|
|
Delete Duplicate Info by
Continental Translations
I have columns A and B filled with information. The information in A1 refers
to B1, A2 to B2 etc..... In some of my cells, there is duplicate
information, and...
|
June 17th, 2004 03:46 PM
by Andy B
|
1 |
449 |
|
|
Circular Reference with Data Validation by
I'm trying to get the following formula to work. I16 is a
data validation list (drop down list) and I keep getting
the circular reference error message, can...
|
June 17th, 2004 03:50 PM
by JulieD
|
2 |
194 |
|
|
formatting output of if statements by
J.F.
Does anyone know of any way to format the output of an if statement? I'm looking to do a very simple if statement and then based on the output I want the text...
|
June 17th, 2004 03:51 PM
by Andy B
|
3 |
210 |
|
|
pivot table by
tim
Cannot use the shortcut 'ctrl+shift' when selecting
within existing table- but am able when create new.
|
June 17th, 2004 03:56 PM
by tim
|
0 |
129 |
|
|
VB for Apps Confusion by
cincode5
Sorry to post this here and on Developer page, but hopefully one of you VB experts out there can help clarify something for me. I want to learn VB and can get...
|
|
2 |
557 |
|
|
Paste Data to Sheet programatically by
gregory
I want to be able to "Copy and Paste" one Sheet to another using the
Excel Com component for version 2000.
At the moment I have written something like the...
|
June 17th, 2004 04:11 PM
by gregory
|
0 |
295 |