|
|
Active Workbook by
Kim
Using Excel 2007, I have a macro where I use a workbook, then save as a new
named workbook. I want to keep the original workbook open. What code
language...
|
|
8 |
710 |
|
|
formula for averages by
JNSteiner
I have to compute the last 15 scores and obtain an aveage for Special
Olympics entry. I want to be able to have a formula which goes up the column
until it...
|
|
1 |
372 |
|
|
|
|
3 |
453 |
|
|
Filling Out Cells Based on Data Validation by
Ericc
I have created a drop down list using data validation. What I need to do now
is have cells filled out based on the value selected.
In this case, the list has...
|
|
1 |
404 |
|
|
Delete rows data moving by
njoseph
When I delete a row in excel 2007 the data that is with with the rows below
does not move with it. the actual text and color formatting will move, but
the...
|
|
3 |
395 |
|
|
|
|
1 |
361 |
|
|
Hidding rows when sorting by
jodleren
Hi all
I have a sheet, where I upload informaton - some rows are hidden
(parts already in stock)
So, when they sort by some coloumn, it shows all rows, and...
|
|
1 |
395 |
|
|
MATCH returning #N/A by
JEB
I'm having MATCH returning #N/A for some items in the list and not for
others. I can't figure out why.
Here's the...
|
|
3 |
364 |
|
|
How do you stack 3 words in one cell by
Tami Sawyer
I am trying to figure out how to put the text "monthly rental pmnts" all in
one cell so that they stack on top of each other. Any suggestions?
|
|
3 |
460 |
|
|
save a file on a CD. by
Ralph Walters
I want to save a file on a CD. When I try, I'm told it is not a legal
operation ( or something to that effect) and that I must get permission from
the...
|
|
1 |
341 |
|
|
Information for Pivot Table by
HL
I have a column with the following information:
F2=1/3/2010
F3=1/15/2010
F4=2/14/2010
and so on
I'm creating a Pivot Table to display this information and...
|
|
3 |
478 |
|
|
|
June 1st, 2010 10:08 PM
by Nadine
|
0 |
401 |
|
|
|
|
2 |
430 |
|
|
Excel 2007 format cells to date format by
Stefan
Hi
got a problem with excel. everytime I open a file the cells are formated in
a date format and I have to reformat them.
Any suggestions to solve...
|
June 1st, 2010 09:06 PM
by Stefan
|
0 |
398 |
|
|
"Save file before closing" by
mkilbour
Using Excel 2007 on Windows XP: Monthly I select hundreds of Excel files from
Windows Explorer, right click and select Print. It would open an Excel file,...
|
|
2 |
392 |
|
|
|
June 1st, 2010 08:02 PM
by Bob I
|
4 |
442 |
|
|
Grouping Time in Pivots. by
GEM
I have a large DB, this is a small example,
Client Date Time
1 5/31/2010 9:32:43 AM
1 5/31/2010 9:34:21 AM
1 5/31/2010 10:51:39 AM
3 5/31/2010 11:10:13...
|
|
2 |
329 |
|
|
how to start a new thread? by
Jack Sons[_2_]
Sounds crazy, but I can't post a question in a normal way. I see the button
on the upper left side that has the name "New". When I click it there appear...
|
June 1st, 2010 07:58 PM
by Bob I
|
3 |
290 |
|
|
Excel not opening documents correctly by
s.edwards
I double click an Excel file in windows explorer, Excel starts, but the file
doesn't open. Minimize Excel and then maximize and the file is open.
Using 2007....
|
June 1st, 2010 07:55 PM
by Bob I
|
3 |
379 |
|
|
|
|
1 |
357 |