|
|
need to fix file title in macro by
leeners82
I have the following macro created which allows the user select a file
from which a worksheet is copied in to the 'report' sheet of the
macro-containing file. ...
|
|
1 |
463 |
|
|
|
|
5 |
591 |
|
|
Maximize setting when opeing excel by
rollingdan
When I open my Excel program my spreadsheet is always less than minimized. Very annoying as I always have to maximize before doing anything. I tried...
|
|
7 |
477 |
|
|
cell format by
Jean
Could I get the correct way to format cells in Excel 97
SR2 to include text and numbers? For example, I need the
string L1234567891 to show as L-123-456-7891....
|
June 15th, 2004 11:42 PM
by Jean
|
2 |
352 |
|
|
Row Hidden or height set to 0 by
CS
The A1 row in my worksheet is not visible and I can't find
a way to display it. Following help, I went to Edit/Go
To/"A1" then Format/Row/Unhide or Height = 13...
|
June 15th, 2004 11:44 PM
by CS
|
7 |
337 |
|
|
Drop downs by
Neil R
I have an excel worksheet which contains 3 seperate worksheets into one. I have managed to use the drop down function on the main worksheet from data used on...
|
|
2 |
521 |
|
|
Adding the DAY to a Date field? by
Earl Kiosterud
Dave,
I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only...
|
|
3 |
272 |
|
|
Hiding Checkbox from "Forms" Toolbar by
bg18461
I have some rows that I want to hide in my spreadsheet, I also have
checboxes within those rows to hide. When I hide the rows, the
checkboxes remain. I know...
|
|
6 |
564 |
|
|
Macro needed? by
Continental Translations
I am after something which will delete excess spaces in certain cells. In
some of my cells, I have a couple of words. Some of these words however have
2 spaces...
|
|
8 |
334 |
|
|
email attachment by
rgm
I have been sent email attachment with .xls extension. I
do not have excell on my computer. Is there a way to open
the attachment? Thanks for your help.
|
|
1 |
273 |
|
|
|
|
1 |
402 |
|
|
create datevalue yyywwd by
jocke
is there any way to create the datevalue yyyywwd (year, weeknr, day of
week) from today's date? in vba code or/and in a spreadsheet
tia
/jocke
---
Message...
|
|
2 |
341 |
|
|
choosing from drop down lists easily by
Dave W
I have several lists that appear as a result of
selections from other list through data validation.
Is there a way to go right to say ..all the words...
|
|
1 |
306 |
|
|
Calendar Mail Merge?? by
JMax
Good Afternoon,
I have a fairly simple spreadsheet with less than 10 columns. Each
item (row) contains 3 dates, Open Date , Close Date and Live Event.
Is it...
|
|
1 |
345 |
|
|
Custom Fill Colors Issues by
G. Sesame
Hello.
I have saved three custom colors in my fill color box. Whenever I send a file containing these custom colors to another user, the user doesn't see the...
|
|
3 |
551 |
|
|
TextToColumns question by
Arch
I want to split full name column into three columns, first, middle, last. Some of my full names do not have middle initials. In that scenario, the last name...
|
|
2 |
195 |
|
|
Copy & Paste sections of data by
Christine Wilso
I receive data each day exported into an excel file. In column A there
is a list of Areas, in column B a list of months from April to whatever
the month we are...
|
|
1 |
330 |
|
|
Excel Manual Calculation is stubborn by
Hari
Hi,
I set my Excel options -- calculation to manual because I have one very
heavy sheet.Last 3 weeks or so I didnt change the option.
Now, I want to change...
|
|
7 |
638 |
|
|
Calcuating % of increase - negative amts by
Mark
I am trying to calculate the % of increase in revenue
from one year to the next.
If Cell A2 (2003) is $100.00
If Cell A3 (2004)is $500.00
% of Increase in...
|
|
5 |
421 |
|
|
palindromes by
thank you
Looking for palindromes solution.
Something that would print number of steps and the end result when a number entered in cell A1.
Thank you!
|
|
1 |
197 |