|
Signatures in Mail merge
Ron de Bruin gave me a mail merge that works perfectly- but would like to
include "conditions" text at bottom of each mail- any idea how to do this
automatically
--
Thanks for your help...
|
5 |
12/22/2008 7:23:00 PM |
|
|
How do I change the size of the text in a worksheet tab?
My tabs take up the whole botton and I have to scroll across to see them all.
The text is at least 12point.
--
dm...
|
3 |
12/22/2008 7:14:44 PM |
|
|
How do I multiply a figure
I am trying to multiply a figure from worksheet tab 1, lets say 5, by a
figure in worksheet tab 2,let say $20.00 with the results being in tab 2?
$20.00 (from tab 2) x 5 (from tab 1) = $100.00
I would appreciate any help with this, thanks so much...
|
3 |
12/22/2008 10:37:31 AM |
|
|
find and replace issue in macro
Hello,
I have a macro in Excel 2007 where I do a copy from one spreadsheet file and
special paste to another sheet in another file. This works fine and it was
created by recording a macro and then doing some minor modifications. I
wanted to then do a find and replace where I make certain rows bold and a
different color, so I recorded another macro to see what it did so I could
insert ...
|
3 |
12/21/2008 11:50:49 PM |
|
|
How to make identical cell datas active to allow changes
How to create a command formula that could allow me activate cells containing
identical data thus make changed data or color fill?...
|
6 |
12/21/2008 5:42:48 PM |
|
|
How do I restore the calculator accessory that was deleted?
I accidentally deleted the calculator and it is totally gone from my recycle
basket and C: drive. It is not available from the menu or from Excel. Can
someone help me with reloading it. ...
|
2 |
12/20/2008 9:19:02 PM |
|
|
How to find/edit combo box source?
I inherited and Excel 97 spreadsheet, and cannot figure out how to
EDIT the combo box used for a drop down list. I can create a combo box
from which to select values, but can't EDIT an existing combo box and
can't find the values that are being referenced in the drop down list.
This spreadsheet has a lot of those combo boxes, and I really need to
be able to edit rather than recreate.
Any ...
|
4 |
12/20/2008 12:31:30 PM |
|
|
need to total by date
A B C
Date Amount if Jan total
if feb total if Mar
Jan, 21 2500.00 2500.00
Feb 10 3200.00 0.00
3200.00
Mar 19 5698.00 ...
|
2 |
12/20/2008 3:31:00 AM |
|
|
Insert row including formula
I have a simple spreadsheet that automatically updates the bank balance
when debits/credits are entered on a new row.
Row D = Debits Row E = Credits Row F = Balance
=IF(Debits+Credits >0,F308-Debits+Credits," ")
However, when I insert a row, the formula above does not repeat
automatically. I have to drag it down into the blank column F cell to
enable it.
For some unf...
|
4 |
12/20/2008 1:40:04 AM |
|
|
How do I change text from Black on white to white on black?
I also would to add a 5 cell bar starting white and gradually changing to
black....
|
2 |
12/19/2008 9:43:08 PM |
|
|
formula help
Hi
I'm working on a sheet with 3 columns
A1 B1 C1 D1
=Date ran =use buy = blank or =days remaining
no work from
todays date
to use buy date
example:
...
|
6 |
12/19/2008 9:28:08 PM |
|
|
Macro
PLS. TELL ME HOW I ACTIVATE MACRO OPTION, IN EXCEL 2007.
SUPRIYA BANERJEE...
|
3 |
12/19/2008 6:03:57 PM |
|
|
Topics on Electronics
Electronics is the field of manipulating electrical currents and
voltages using passive and active components that are connected
together to create circuits. Electronic circuits range from a simple
load resistor that converts a current to a voltage, to computer
central-processing units (CPUs) that can contain more than a million
transistors. The following indices and documents provide a basic...
|
2 |
12/19/2008 4:40:13 PM |
|
|
How do i design my own webpage?
I am trying to find out how i can design my own webpage to gather donations
of furniture and clothing etc for the less fortunate in my area and also find
the individuals who need this type of help. How do I go about it? ...
|
2 |
12/19/2008 8:54:06 AM |
|
|
Topics on Electronics
Electronics is the field of manipulating electrical currents and
voltages using passive and active components that are connected
together to create circuits. Electronic circuits range from a simple
load resistor that converts a current to a voltage, to computer
central-processing units (CPUs) that can contain more than a million
transistors. The following indices and documents provide a basic...
|
1 |
12/19/2008 8:14:59 AM |
|
|
Formatting Rows
I want to have a spreadsheet with columns that have different sizes. I want
perhaps 10 columns with one margine/size and I want to be able to change the
colum size for the next 20 rows without changing the columns above them. Then
I want to be able to print the sheet. Any ideas?...
|
6 |
12/19/2008 7:59:02 AM |
|
|
Income Tax using US Tax System Excel WorkBook
Hello, I am looking for Excel Template to calculate Tax using US tax
brackets. Can anyone please post a link for it. I have looked up
cannot find it on web. Someone got it? Please post a link or
webaddress if you got any idea. Thanks....
|
2 |
12/19/2008 7:32:01 AM |
|
|
color shading for text entries
hello all,
you will laugh at what i am trying to do, as it is pretty simple, but i do
not know how to do it. i am using a spreadsheet as a calendar, and i would
like to enter a character into a cell and then have that cell turn a
particular color. there are five different characters that i would like to
use...D, H, P, B, and J.
i would like the D character, when entered, to turn...
|
4 |
12/18/2008 9:26:02 PM |
|
|
percent formula
Anyone please!
How do I write a formula that gives me the total after deducting %.
Example if I have $25 and I need to deduct 14% and I need to show the total
which
would be 21.50
--
smile...
|
4 |
12/18/2008 7:39:21 PM |
|
|
Please help w/formula
I want to create a formula for an employee schedule to compute the totals hrs
scheduled, multiply total hrs scheduled by rate of pay to get a gross rate of
pay. I can only get it to add up to 24 hrs then it starts over at 1.
Example I am using:
Start:17:00
End: 19:00
Total: =(end-start)...
|
4 |
12/18/2008 6:16:25 PM |
|
|
Place a button on a worksheet and assign a macro to it?
How do I place a single "button" on a worksheet (say, in one cell), and
assign a macro to it?...
|
8 |
12/18/2008 3:28:10 PM |
|
|
i am lost
i can use the excel sheet!!i am getting very nervous and loosing patience
...too complicated ...now the most frustated is that vene tehcurrent excel
sheets saved are blocked and i can not do anythin g with them ,it wo rks
before adn now there are not disabled ..do not know what to do ..pls
help!!!!!!!!!!
--
ng...
|
6 |
12/18/2008 1:52:44 PM |
|
|
Similar nos.
Dear sir,with my regards, i enclosed herewith afile asking you for
help.
Thanking you.
+-------------------------------------------------------------------+
|Filename: Similar nos.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=127|
+-------------------------------------------------------------------+
--
tofimoon4...
|
3 |
12/18/2008 1:49:17 AM |
|
|
Formatting cell based upon values w/in a selection
Background: I have a spreadsheet which tracks 10+ training course dates for
100+ individuals. All dates have conditional formatting applied to turn red
if the date is <=TODAY(), yellow if btwn TODAY()+1 and TODAY()+30, and amber
if the date in the cell is btwn TODAY()+31 and TODAY()+60.
Dilemma: Column A, for each individual, needs to reflect their overall
status (preferrably usin...
|
2 |
12/17/2008 7:04:05 PM |
|
|
conditional format of adjacent cell with different range and crite
Well I have to Conditional format a range of values of range of string
character. For Eg. Column A contains Weekdays, 5 Mondays,3 Tuesdays, 2
Wednesday, 7 Thursday, 2 Friday, 3 Saturday and 6 Sunday in Column A. With
having range of values from 30 to 100 in the adjacent cells of Column A.
Col A Col B
Sunday 32
Sunday 65
Sunday 52
Sunday 69
Sunday 45
Sunday 85
Monday 63
Monday 25...
|
2 |
12/17/2008 6:58:01 PM |