|
|
|
May 22nd, 2005 11:50 AM
by miltdp
|
2 |
201 |
|
|
|
|
3 |
156 |
|
|
Cells.Find , why it DOESN'T search ? help by
Andrzej
hello everyone,
I have two file. When I work in first file (p2.xls) i need to find something
in second file(p1.xls). Then write in the ActiveCell of p2.xls,...
|
|
1 |
117 |
|
|
Macro "If Then" by
Benny Benny via OfficeKB.com
I want to use a macro to cut a range of data and place it into a different
worksheet. It looks like this:
Cell A6 is a Validation list with 3 names. Each...
|
|
1 |
113 |
|
|
how to write a formula by
wolfmasterr
I have just taken over as manager of a boarding house and need to come up
with some formulas to allow me to enter a dollar amount in cells c1:c12 and
then have...
|
|
3 |
119 |
|
|
Multiple Criteria for SUMIF by
camerons
I have the following list of info:
!----A----!----B----!----C----!----D----!
! 2/3/05 ! 114 ! 4.5 ! !
! 2/3/05 ! 114 ...
|
|
3 |
145 |
|
|
Formula questioin by
Karen53
Hi,
Cell E2 gets the hours. Cell F2 has the conditional statement
=IF(BZ540,BZ5-40). I then need cell E2 to change to 40 hours. Is there a
way I can do...
|
May 22nd, 2005 07:14 PM
by Andy B
|
4 |
109 |
|
|
User Form Code by
mully
Hi
I'm using an Excel sheet named Customers. In cell S302 I have a running
total of all customers purchases . I have inserted a Text Box on the user
form -...
|
|
9 |
234 |
|
|
Formula help by
George Gee
Hi all
In cell G7 I have a football score, (user input) in the form of (e.g.) 2 2
(note the space between the two numbers).
In G6 I want a formula that...
|
|
5 |
120 |
|
|
Entewring long numbers into Excel by
Misha
I am very new to Excel. When I enter a long number into a cell I get a
formula I do not understand. Even if I widen the column, the formula stays.
and the...
|
|
2 |
177 |
|
|
Protecting and Hiding formulas by
Pav
I have password protected a spreadsheet that shows various costings. When I
copy and "Paste Special" onto a new sheet with "Formulas", "Values, "Formulas
&...
|
|
3 |
305 |
|
|
Replace. by
Rodney
If I am given a very large formula as assistance
with A1 as usually offerred as example.
How may I do a bulk "Replace" when fitting the formula
to cell say...
|
May 23rd, 2005 03:41 AM
by Max
|
3 |
110 |
|
|
wordxml in excel 2003 by
manoj
How can i open the wordxml file in excel with the same format as in wordxml...
|
May 23rd, 2005 06:59 AM
by manoj
|
0 |
85 |
|
|
wordxml in excel 2003 by
manoj
How can i open the wordxml file in excel with the same format as in wordxml...
|
May 23rd, 2005 06:59 AM
by manoj
|
0 |
103 |
|
|
Date & Time by
mully
Hi
Is there a code I can insert in VBA that will constantly update - the time
and date in two separate text boxes on a User Form. That I use now - I know
how...
|
May 23rd, 2005 11:56 AM
by mully
|
4 |
556 |
|
|
Maddening reference error by
Wowbagger
Using Excel 2003 on an XP pro machine I created a 5 sheet workbook.
On (named) sheets 2-5 column A has a date, columns B and C has a number,
column D is equal...
|
|
2 |
122 |
|
|
User Form Picture by
mully
Hi
I'm trying to insert a small jpeg on a User Form in the bottom left hand
corner - its about 6cm x 5cm - I can insert a picture within the VBA however
its...
|
|
3 |
145 |
|
|
|
May 23rd, 2005 08:44 PM
by FxM
|
1 |
288 |
|
|
|
May 23rd, 2005 11:31 PM
by Max
|
1 |
91 |
|
|
how do I substract by
kiserlouisa
I am new to this. I am trying to do balance sheets. I need to add the rows
(which I have been able to do) then substract the 2 columns. I cannot
remember...
|
|
1 |
122 |