| Thread | Last Post | Replies |
|
| short cut way to go to specific but unknown cells | 09 Dec 2004 22:55 GMT | 3 |
Is there a short cut way to go to the
1) first row first column
2) last row, last column
3) last row, first column
|
| I am trying to automatically compare sum of week-to-date v. previous week-to-date | 09 Dec 2004 22:49 GMT | 2 |
I am trying to automatically compare sum of week-to-date data v.
previous week-to-date data after entering daily stats. Any ideas would
be much appreciated. Thanks!
|
| Formula in text boxes | 09 Dec 2004 22:46 GMT | 5 |
I have heard you can put string arithmetic formula in text boxes. How do
you do this? For example I would like to add the contents of three cells as
follows:
=B1&DOLLAR(B3,2)&B2
|
| slow file open dialog box | 09 Dec 2004 22:27 GMT | 1 |
File open dialog box in Excel 2003 and Word 2003 on W2K machine is
unbearably slow
when attempting to access folders on network drive.
Doesn't appear to be a connectivity issue since accessing same folders in
|
| How can I figure present value of a stream of payments? | 09 Dec 2004 22:05 GMT | 1 |
|
| Please help correct a simple error | 09 Dec 2004 21:39 GMT | 1 |
I am trying to place a value into a string and then
place that value in a cell. I don't what I did wrong but
I am sure it is simple code. This happens in a
CommandButton. I have a combo box on the sheet that has a
|
| how do I put a excel document in word | 09 Dec 2004 21:36 GMT | 1 |
NEED TO PUT an excell budget into a Word proposal but how?
|
| Updating a formula to miss first four characters of a FIND | 09 Dec 2004 21:19 GMT | 3 |
I was very helpfully provided with the below formula yesterday to help me
filter information (thanks to JE McGimpsey):
=LEFT(MID(A1, FIND("SMTP:", A1), 255), FIND("%", MID(A1, FIND("SMTP:", A1),
255))-1)
|
| Excel Help.... | 09 Dec 2004 21:13 GMT | 1 |
I am trying to populate a spreadsheet with multiple information. I have a
listing of counties that I want a single cell to identify (maybe a drop
down?)in an already populated worksheet. Then I want the cell for "tax" to
automatically populate the tax code associated with that ...
|
| protect embeded object | 09 Dec 2004 21:13 GMT | 1 |
I have a worksheet with an embedded Project file.
is it possible to protect the worksheet to not allow users to delete the
embedded file,
but to allow them to edit the embedded file?
|
| Hiding Rows Conditionally | 09 Dec 2004 20:22 GMT | 1 |
Is it possible to hide a row only if a certain cell in the
row contains a reference to another cell that has a specific
value?
Here's the scenario:
|
| Inserting parentheses to a phone number | 09 Dec 2004 19:30 GMT | 1 |
Trying to change
+1 201-963-6572
to
+1(201)963-6572
|
| Odd problem with charts... narrow! | 09 Dec 2004 18:31 GMT | 1 |
Hi all.
Odd thing started happening with Excel 2002 (WinXP).
When I load workbooks that contain chart sheets... the charts are no longer
their "normal" size, but are narrow (about 1/2" wide on my monitor) but are
|
| Excel drop-down values versus labels | 09 Dec 2004 18:29 GMT | 1 |
I can't figure out how to duplicate Web-based Select boxes, as drop-down
lists in Excel.
I can create the drop-down list using Data | Validation | Settings,
selecting from Allow the opion List (Ignore Blank and In-Cell dropdown
|
| copying fomula | 09 Dec 2004 17:40 GMT | 14 |
Hi Does anyone know how i could copy or fill down this formulae =A2*B1
written in B2 to the cells B3, B4 and so on? The two variables are only A1
and B2. I can do this the normal copy and paste way but wondered if there
was a much quicker way to show children in my class at school.
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread