|
|
with ref to the dialog editor question by
DAVE P
A few days ago I posted a question about "dialog editor." (please see below) Perhaps I was asking the wrong question.
I'm trying to create a form to input...
|
|
1 |
308 |
|
|
Protecting a worksheet by
YS
I am trying to see if there is a way to protect a
worksheet, but leave a few cells unprotected (including
their formats). I want to be able to change the color...
|
|
2 |
188 |
|
|
autosave/add-ins by
Yogii
I'm not very familiar with Excel but have a couple of files out of necessity. Recently, as I was working on one, there was some kind of error and it had to...
|
|
3 |
120 |
|
|
How to vary column widths by
tsac1234
I have a four page worksheet and have managed to make it work with the
same column width on all four pages. However, I would like to have
different widths on...
|
|
5 |
153 |
|
|
Excel to Lotus by
xippy
Is there a way to convert an MS Excel spreadsheet to Lotus? I have saved an
Excel file, but it's Read Only for some reason, and doesn't...
|
|
1 |
171 |
|
|
Athos by
Athos
is there a way to write this as a formula?
I want each cell (B1:B10) to refer to a fixed cell(A1) in
the following way:
Cell B1 = $A$1 * n. Where n is a...
( 1 2)
|
|
13 |
234 |
|
|
pop-up/comment of text in chart by
acl
Hi
I am basically brand new to VBA and excel macros...so please keep that
in mind. If the solution lies in either of those, if you would be kind
enough to...
|
|
2 |
202 |
|
|
Data validation input message by
DT
Can anyone please offer any advice? ..... I am using data validation on a
worksheet and would like to resize the message box that appears when the
cell is...
|
|
8 |
221 |
|
|
Reduce chart white space by
Vinod
When I create a pie chart, a terrible amount of white space exists
around the pie. When I insert it into PowerPoint, it takes up way too
much room.
I can...
|
|
2 |
420 |
|
|
count if by
gregork
I need a formula to return text based on that text being in all the cells in
a range. I want the formula to ignore blank cells in the range. I have...
|
|
6 |
249 |
|
|
|
|
2 |
2,116 |
|
|
Using formulae to display pictures.... by
matt_123
Hopefully there is somebody that can help me with this predicament. I
regularly compile quizzes on excel which get sent out & are now viewed
as far afield as...
|
July 3rd, 2004 10:32 PM
by AlfD
|
2 |
351 |
|
|
Work menu in Excel? by
billlake
~× wrote:
*Very handy feature in Word. It's a menu where you can add the
documents you work most frequently with. Much better than the Recent
Files...
( 1 2)
|
July 3rd, 2004 10:15 PM
by Andy
|
13 |
678 |
|
|
Matching by
gary
a1..e711 contains data in this format:
Part-nbr Date Amount
008101815-8 03/12/2001 751.72
008101816-9 03/12/2001 514.50
008101817-0 03/12/2001 ...
|
|
2 |
158 |
|
|
Auto refresh of Pivot Table by
K. Georgiadis
I found the following code on C. Pearson's website:
Sub Auto_Open()
Application.OnSheetActivate = "UpdateIt"
End Sub
Sub UpdateIt()
Dim iP As...
|
|
2 |
112 |
|
|
AutoFilter not an Option by
Jeremy
I have a large spreadsheet with multiple columns of data. Each column has a label and no column is left entirely blank. When I go to the Data:Filter menu the...
|
July 3rd, 2004 04:41 PM
by Jeremy
|
3 |
139 |
|
|
filter out all the #n/a... by
sokevin
I have done a vlookup in col(b), col(c) and col(d)
i want to summarise column b,c,d in column E
e.g
if col b2 = #na, c2=#na, d2=300 then i want e2=300
if...
|
|
2 |
160 |
|
|
|
|
7 |
904 |
|
|
date and sending message by
rpahl
I am trying to create a macro that sends a specific number to a
specific cell on a certain day.
"If the first day of the month, then send 75 to cell A2
If the...
|
|
2 |
145 |
|
|
|
|
1 |
156 |