|
|
|
|
0 |
101 |
|
|
|
|
1 |
170 |
|
|
Auto populate fields by
Mark
I have a form that asks for Name, Job Title, Employee ID number, etc. I can
create a drop down list using Validate no problem. However, I want to be able
to...
|
|
1 |
99 |
|
|
Verify if Comment exist in a cell by
Tom LeBold
How do you verify if a comment exist in each cell in a worksheet using VBA
code.
The following VBA code works for a verifying comments in a range:...
|
|
2 |
166 |
|
|
default save as by
johnw
when we opened an excel from our server via office 97adn then saved using the
save as function ,it would take the perticular pcs current directory.Now on
using...
|
|
6 |
260 |
|
|
Break link MS Excel 2000 by
PetroChris
How can I break a link to another Worksheet in MS Excel 2000? Edit -- Links
doesn't have a Break Link option in this version of Excel.
I tried Select All...
|
|
1 |
175 |
|
|
|
|
2 |
75 |
|
|
Fields in a record are on the next line by
Dan
I have a SS with six fields as follows:
Record 1-
A1, B1, C1, D1, A2, B2
I want to move A2 to E1 and B2 to F1 so Record 1 is on one line.
The present...
|
|
4 |
96 |
|
|
|
September 15th, 2005 09:31 PM
by swatsp0p
|
1 |
91 |
|
|
|
September 15th, 2005 09:35 PM
by tcom
|
7 |
296 |
|
|
Superscript in a Custom Format by
Sloth
I use custom formatting to display units (such as "28 in²"). I need in^4
though and can't figure out a way to get it to show like m² or kg³. Does
anyone...
|
|
1 |
136 |
|
|
Nested if question by
dakotasteve
In the cell where the formula resides, I get a FALSE result. My
intention is that I get a message that says "No Deprec. this yr". My
formula is as...
|
|
3 |
111 |
|
|
formula to get sheet name by
Nigel
hi,
can a formula retreive a worksheet name or does it need to be macro based?
thanks,
N.S.
|
|
3 |
93 |
|
|
|
|
0 |
275 |
|
|
format date in excel by
Nigel
hi,
Can you format a date in a formula to recognise the date only? i have a
column with the day number only and need to calculate the figure directly to
the...
|
|
2 |
264 |
|
|
Pasting Columns by
Humbertt
I have a list of names in a column (for example A1:A100) and would like to
paste it into another worksheet; but in a way that it skips every other...
|
September 15th, 2005 09:52 PM
by bill k
|
2 |
87 |
|
|
List Conditions by
Kate
I'm creating a timesheet form and want to be able to populate a list of job
codes specifically by client.
For example, in the "Client" Column you select Client...
|
September 15th, 2005 09:55 PM
by Kate
|
3 |
162 |
|
|
sorting using macro by
Ross
I created a series of macros that sort my spreadsheet by a different column
heads as needed, and assigned them to buttons, so I can sort by those
column when...
|
|
2 |
99 |
|
|
Timesheet by
Matt
Hi all
Ive got a timesheet woking now for my company but they are wanting me to add
2 more colums for flexi one for how much im in credit with...
|
|
3 |
91 |
|
|
Format date to put in / or - by
DKR
Can you format a cell so that you can just put in 091505 and it will enter it
as 09/15/05. Sure would save me some time.
|
|
1 |
72 |