|
|
Excel formula question - nested VLOOKUP? by
brightshadow
So far, I have a VLOOKUP function that searches another sheet and pulls
the data from a cell matching a name located in row 4 of the same
column, and converts...
|
June 30th, 2004 10:12 PM
by AlfD
|
4 |
271 |
|
|
Currency Symbol Problem - Costa Rican Colon by
SteveT
When I attempt to format my column of numbers using the
format cell, currency feature , I select Spanish Costa
Rican Colon which shows in the drop down box as...
|
June 30th, 2004 09:50 PM
by SteveT
|
0 |
689 |
|
|
|
June 30th, 2004 09:42 PM
by jeff
|
1 |
408 |
|
|
Format Number by
Becky
I have numbers that import into Excel and they come in
with the General format.
Example: 34350
The number is actually the amount of a check for $343.50
I...
|
June 30th, 2004 08:37 PM
by Becky
|
2 |
529 |
|
|
Setting Tab Order by
Shawn
I want to control the cells I navigate to when pressing the tab key. I have protected the worksheet and some cells are locked, which are being skipped as I...
|
June 30th, 2004 07:09 PM
by RagDyer
|
1 |
298 |
|
|
QUESTIONS ANSWERED by
[email protected]
What really causes crop circles?
Can a full moon really cause people to act strangely?
How does mint make your mouth cool?
ALL Questions n More Answered Here ...
|
|
0 |
443 |
|
|
Automatically Fill In Pirces by
Denise
I am wanting to set up a spread sheet to track charges that are lost monthly. I will be entering a product number from charge stickers that are found in the...
|
|
1 |
372 |
|
|
Keep my A column visible by
webbynet
Hi,
I am trying to keep the A column visible while i scroll right through
the columns. I need to be able to see column A. I have tried freeze but
having some...
|
|
3 |
258 |
|
|
Automatically deleting duplicate rows?? by
Ritchie Jones
Hello,
I have searched through the help but couldnt find out how
you can delete duplicate rows in an Excel spreadsheet
without having to manually go through...
|
|
3 |
529 |
|
|
Numbering Add-In by
Carolin Devaney
I have a purchase order template I created with Excel 97
which includes an automatic counter field to give each PO
its unique ID number. When I try to open...
|
|
2 |
363 |
|
|
How to create a digital certificate... by
hermes
so that I can use it to locally sign my office files (word and excel). I
do not want to continue to be prompted to enable or disable macros for
each of my...
|
|
8 |
285 |
|
|
saving worksheets as individual files by
Paul Mendez
I have a workbook with over 250 worksheets. I would like to separate
the workbook into individual worksheets. What I mean is that I would
each worksheet to...
|
|
3 |
417 |
|
|
Deleting a Folder by
BillCPA
I want to use a macro to do a backup to CD. I am using .FolderExists, .DeleteFolder, .CreateFolder, and .CopyFolder. The folder I am copying to is on the...
|
June 30th, 2004 04:01 PM
by BillCPA
|
2 |
196 |
|
|
Decimal separator from Excel 2000 by
freeposte
Hi there I'm running under Windows XP using Excel 200 from the Pack Office
2000.
I'm wonder how could I change ciffer decimal separator on Excel 2000.
On...
|
|
1 |
750 |
|
|
|
June 30th, 2004 03:08 PM
by cp
|
9 |
745 |
|
|
Sorting more than 3 pieces of data?? by
StargateFanFromWork
Wow, I've _never_ had this happen before. I have a spreadsheet that has 4
columns, 3 that are often extremely similar. It's the 4th one that has the
most...
|
|
7 |
225 |
|
|
|
|
8 |
261 |
|
|
Multiple sheets sharing variable data by
x65140
Sheet1, Column A contains variable data entered. (Red, Blue, Green,
Blue, Green, Red, Green Red, Blue)
When the data is entered into Sheet1, I want it to...
|
June 30th, 2004 12:00 PM
by x65140
|
2 |
211 |
|
|
|
|
2 |
225 |
|
|
Formatting entries in userform textbox by
RobG
I'm using a userform for enter dates and times into a
worksheet. is there a way of formatting the data as it's
input like in an Access form? or is there a way...
|
|
7 |
267 |