|
|
Data-Filter on Multiple Entries in Cell by
XLML
Hi, I am new to the board and using XL2002.
There are instances when I enter more than 1 entry in a cell. For
instance, cell A2 can have the 12 months of...
|
June 24th, 2004 01:38 PM
by XLML
|
2 |
169 |
|
|
Excel Edit - Copying problem! by
ttask
Looking for an idea of how to copy parts of a spreadsheet, ignoring
hidden cells.
I just want to paste exactly what I see!
Thanks in advance!
---
Message...
|
June 24th, 2004 01:04 PM
by Andy B
|
1 |
160 |
|
|
current time on excel by
pikapika13
Right now I am using =Now() to display the current time. However, this
isn't perfect bc it only gives the time when there was last activity on
the workbook. ...
|
|
3 |
398 |
|
|
displaying comments by
tjtjjtjt
Is there a way to make Excel display a comment when a cell is selected (as opposed to moving the cursor over the cell)? And, is it possible to make the comment...
|
|
9 |
292 |
|
|
To make the macros know about added rows by
Lana
Hi Subj.
I have the subtotal of a few columns. How do I make this subtotal
update if new rows have been added?
ThankS a lot.
---
Message posted from...
|
June 24th, 2004 11:54 AM
by Lana
|
4 |
181 |
|
|
Last Day of a Week based on NOW() by
beeawwb
Good evening all,
Just a quick question. How would I work out what all the days in a week
are, based upon the current date.
So, have 7 cells, which would...
|
June 24th, 2004 10:34 AM
by beeawwb
|
2 |
139 |
|
|
Vlookup and IF function problem by
yuste
Hi,
I would like to do a kind of double Vlookup.
I have 2 different worksheets with following information:
Worksheet1 is the master file with all modells: 3...
|
June 24th, 2004 07:43 AM
by yuste
|
4 |
298 |
|
|
Recovering old versions of saved files by
Spyder
Is it possible to recover an old version of an Excel file after saving it without changing the file name? Autorecover is on.
Thanks for any help!
|
|
3 |
158 |
|
|
Filtered Rows using Mode Function? by
QTE
Hi Excel Forum,
I am using numeric "filtered" data and I need to find the most frequent
/ re-occurring values (1st, 2nd, 3rd, 4th, 5th etc.) from the...
|
June 24th, 2004 03:35 AM
by QTE
|
4 |
349 |
|
|
Importing address from Excel to Word by
NeWcS
I have a list of addresses(see attched file) and I want to insert them
into a word document. Can this be done?
Thank you.
-Jay
Attachment filename:...
|
June 24th, 2004 03:09 AM
by NeWcS
|
3 |
341 |
|
|
find question by
Steve Goodrich
how do i find information in a workbook?
i've tried selecting all the sheets but only seems to finf results in the
first sheet
i need to seach the whole...
|
|
1 |
144 |
|
|
Populating a ListBox by
ToddG
I'm sure this is probably pretty simple, but how do I
populate a ListBox with only the populated cells in a
worksheet?
For example:
Column A Column B ...
|
|
1 |
229 |
|
|
|
|
1 |
154 |
|
|
require cell entry by
kmcgee
I have set data validation to require either a 0 or 1 be entered in the range 'g5:h4740'. Is there anyway to require the data be entered and not allow someone...
|
|
2 |
235 |
|
|
|
|
1 |
307 |
|
|
Excel version compatibility problem? by
sue1201
6 people are sharing a single Excel spreadsheet over the network. Until
recently this was not giving any problems at all.
Some of them use XP Pro computers...
|
|
1 |
487 |
|
|
|
|
2 |
156 |
|
|
different workbook by
andy
I have the following macro:
Sub Temps()
Dim myRange As Range
Dim mySheet As Worksheet
Set mySht = Worksheets("Temp...
|
|
1 |
138 |
|
|
Excel protecting formatting by
Rob
Hi All
How can I prevent cell formats from being removed or
being overwritten when data is cut or pasted from another
cell.
I do not wish to rely on users...
|
|
1 |
199 |
|
|
hyperlink greyed out by
Yosef
Excel XP windows XP
I have a document with many sheets and an index page. The
index page refers to the various sheets with hyperlinks. I
just added a new...
|
|
1 |
236 |