Automatically copy formula in column when adding new row....
Hello all. Sorry if I am posting this question in the wrong category, but
this is my first post here.
I am using Excel 2007, and I am trying to automatically copy a formula
that's in a column when I add a new row. I'll explain a little more in
detail what I am hoping to achieve.
My spreadsheet is intended to show profit and loss for my sales. Columns
A:W all have details specific to the products that I am selling, including
original purchase price, sale price, shipping, fees, etc... In Column X, I
have this formula " =SUM(Q4:W4)*L4 ", and then in Column ...display a notification when new mail arrives #2
Not sure if this is an Outlook or a Windows question! But here goes. Until
a short while ago, I would get an 'unopened envelope' icon in the systray
when new mail arrived, but now its gone.... Don't think I've done anything
to change this - but it was really useful, so can anyone tell me how to put
it back, thanks
1) Select Options from the Tools menu (in Outlook)
2) Click [E-mail Options]
3) Click [Advanced E-mail Options]
4) Check "Show an envelope icon in the notification area.
Let me know if this helps!
Bay Area DebG
"Jeff" ...1920x1080 how some programs (non-menu area) fonts are displayed
Moving from the 1280x1024 for standard LCD 19" etc screens resolution, to
the 1920x1080 which comes with 23" etc WideScreen monitors these days, we
know the same settings of font size displayed we were use to, will now show
slightly smaller - and that's fine.
First, yes we understand about font size, clear type, and dpi adjustments.
Yes we know for higher resolutions being sure to turn on and adjust
ClearType which solves readability problems just fine across the board in
every nook and cranny, Except, inside many non-microsoft programs where the
OS's control over t...Can no longer display payment address/info for epay transactions
Ya gotta love how things inexplicably stop working in Money, Money 2007 in my
Suddenly, I can no longer display the payment address for any of the epay
transactions in my checking account register. When I select a transaction and
1. Press the Options button and then select "Edit Address: <Payee>"
2. Press the "Pay to:" hyperlink
This is having a nasty side-effect: If I enter a new epay check (i.e., a
withdrawal) to a new payee, I can't submit the transaction. I'm no longer
prompted to enter the address and account number.....error messages 03-03-10
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
Was syncing entourage with mailme when i got an error message. I clicked it off and they kept coming...at one time I had 20 on the screen. I had to close the program and then turn off my Macbook Pro, then turn it on. I cannot use Entourage without this happening...opened it and one popped right up.
On 2010-03-02 22:09:33 -0500, firstname.lastname@example.org said:
> Was syncing entourage with mailme when i got an error message. I
> clicked it off and they kept coming...at one time I had 20 on the
&...What is the Excel formula for adding 1 column with several rows?
I need to the sum of one column - several rows. Example: Column J rows 3 thru
71 without entering each column and row number.
Gord Dibben MS Excel MVP
On Mon, 21 Aug 2006 18:50:51 -0700, ljsbjs <email@example.com>
>I need to the sum of one column - several rows. Example: Column J rows 3 thru
>71 without entering each column and row number.
And a variation that allows you to insert rows immediately
before the formula.
David McRitchie, Mic...moving every other row up 1 row to the next column
I need to move every other row to match with the one above it but place it
the info in the next column.
Column A Column B
PREMARK 24'' WH LN + 15'
PREMARK 12'' WH LINE PLUS 30'
What I need is:
F8432060SP4 PREMARK 4''X4' STRIPS WH 3000'
Try something like the "Vertical to horizontal..." here:
"Rose Davis" <firstname.lastname@example.org> wrote in messag...how does one plot a line-column on two axes in excel?
How does one use Excel 2007 to plot a line and a bar graph with two axes -
the same chhart offered in Excel 2003 under Custom Types?
You have to build the combination chart yourself.
Create a column chart based on both data sets. Select the column you want as
a line and use Change Chart Type to set it to line chart.
Andy Pope, Microsoft MVP - Excel
"gbrunnhoeffer" <email@example.com> wrote in message
> How does one use Excel 2007 to plot a lin...Outlook Contacts Displaying Incorrectly
I synchronise contacts with Outlook and my mobile phone (Nokia 6230). When a
contact comes from the phone it displays as Smith, John in the Outlook list,
however when I open the contact and try to edit it says display as John
Smith. There must be another setting that is overriding this somewhere!
By default, Outlook 2003 displays contact names that are in your Contacts list in the FirstName, LastName format, as opposed to the LastName, FirstName format. In this situation, the first
name of a contact is used to sort your Contact lists because the Contacts lis...Need to calculate time between 2 dates and display Conditional formatting
I have some Excel cells with dates formatted like this Thursday, June
2004 8:53 AM. I need the difference in time (Days Hours Minutes
between the 2 cells containing the dates. What would the formula be?
I was trying this
=DATEDIF('Level 2 Support Team Member'!B7,'Level 2 Support Tea
but I kept getting a #Value error B35 and b7 are merged with cells t
the right for display, but those are the cells that contain the actua
I wanted to Conditionally format the result so that if the result wa
greater than 1 day or 24 hours that the font wou...Outlook Reminders #10
Hope this question has not been answered before.
I have transfered all my business data from SBS 2000 to SBS 2003. I created
all the user accounts from scratch on the new server using the same
usernames as the old server. I then restored all their email to Exchange
2003 using Veritas Backup Exec 10.1 Ever since then no reminders have came
up in Outlook on any PC when the user logs in and runs Outlook. We run
various version of Outlook (2000 / 2002 / 2003) all with the same problem.
When I log in via Outlook web access the reminders appear so I suspect it is
a Outlook t...Add Text Field Columns
I have two fields both of which are text. When I try to add them as above, I get a
concatenated result, not the sum. How does one add them?
On Fri, 18 May 2007 17:38:49 -0600, bw wrote:
> PFDB: IIf(Nz([PFDirect])+Nz([PFBulk])=0,"",Nz([PFBulk])+Nz([PFDirect]))
> I have two fields both of which are text. When I try to add them as above, I get a
> concatenated result, not the sum. How does one add them?
How does one add "This is text." + "this is also text&qu...Form will not display records
In Access 2007, one of our users has asked me to research the following,
She built one form, using fields from 5 tables, each table has a field,
Item_ID, it is the Primary key in all 5 tables, and a 1-1 inner join relates
the 5 tables. She then created the form, using the fields from the tables.
Data entry works perfectly, and the tables get populated, but when closing
the application and then restarting it, the data does not display in the
form, although it is still in the tables.
What could cause this behavior?
What is the SQL feeding the form?
Build a little, test a ...Macro with "relative" range for Average function, or... 'is there a real keystroke recording macro generator?
I often have columns of numbers, with a label, that I need to average (or
get the standard deviation, etc.). The column length varies, and I would
like to not worry about having a constant number of rows between the cell I
am in when I run the macro and the cell with the label.
Manually, I use
end, down arrow ' gets me to the label
down arrow ' first data cell
control shift down ' last data cell
Enter ' completes entry, calculates average
This works fine for other columns of the same length, but wit...Adding Industry Average Line
So I have data;
Plant 1 Y1
Plant 2 Y2
Plant N YN
Company Avg YAvg
Industry Avg YIA
(YAvg is a calc I do, YIA is plugged)
Now. I have a column chart where there's a column for Y1, Y2, etc. etc.
I'd like columns for Y1 - YN. But I'd like a horizontal line for YAvg and YIA.
I know I can "trick" it if I do a combo graph with separate columns of data:
X Y Co Ind
Plant 1 Y1 Yavg YIA
Plant 2 Y2 Yavg YIA
P...###### appearing even though the cell is large enough to display everything
I have a cell with text in it and on my screen it appears as a series
of pound signs. I have made the cell large enough that all the text
should fit so I do not know why the pound signs will not disappear.
Format the cell to General.
Excel has a problem with cells that contain >255 but <1024 characters.
Gord Dibben MS Excel MVP
On 26 Apr 2006 12:55:14 -0700, firstname.lastname@example.org wrote:
>I have a cell with text in it and on my screen it appears as a series
>of pound signs. I have made the cell large enough that all the text
>should fit so I do not know why the pound sign...Re: Two-Column Problem
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Charley Kyd <email@example.com>...
> But now, when I add a pair of pages, Publisher gives me guides for two
> columns per page but gives me only one page-wide textbox per page,
> not two.
Can't you create your text boxes yourself? Or change the text box that
appears to a two-column one?
Ed Bennett - MVP Microsoft Publisher
Before reading this message, view the disclaimer:
...Unable to display default folder in cached mode
I have installed and configured Exchange 2003/Outlook 2003 clients. Some of
them, after creating the Outlook profile, displays "Unable to display your
default folder" message on Outlook stratup and shuts down Outlook. When I
turn off the "Use cached mode", it works fine.
I have tried it on other computers/other users profile and still have some
3-4 user mailboxes with this issue.
There is Novell client installed on computers, but other 60+ users are fine.
Any help would be appreciated.
Do the users having problems have a local or remot...Autofilter for fixed columns
I have a big table from column A to BP, though the number of column is not
fixed. Sometimes it has additonal one or 2 extra columns append at the back,
so it could reach until column BR.
Regardless of how many columns I have in this table, I want to have a macro
that could turn on autofilter, filter column J for a value e.g. "John, C",
and then filter column AC and R for non-blank cells.
I tried the following, but it doesn't work.
..Columns("J:J").AutoFilter field:=1, Criteria1:="John, C"
..Columns("AC:AC").AutoFilter field:=1...Column spacing
Is there any way I can control the spacing between the
columns in the layout guides (chosen from the Arrange
menu)? I want to set 0.7 cm column spacing for a text
frame split into 3 columns and see the guides for this
setting so that I can then use individual text frames on a
I know I can set the column spacing in the text frame
formatting option but this is not reflected in the layout
guides. Please can anyone help?
I am using Publisher 2000. I have this work around - I
make my own ruler. Make pull a rectangle, looking at
the "size" indication in the lower r...Data in columns not rows
I have file that is names, addresses and phone numbers.
When I copy it into excel it comes out like this.
I need it to be like this
COLUMNA COLUMNB COLUMNC COLUMND
NAME ADDRESS ADDRESS2 PHONE
Is there a way to change this without copying and pasting?
Is the data consistently 4 rows? Or do you have varying sets?
How far down Column A do the sets extend?
If 4 rows per set try this.....
In B1 enter =INDEX($A$1:$A$3000,(ROW()-1)*4+COLUMN()-1,1)
Drag/copy across to E1 then select B1:E1 and drag/copy down u...Simple 3D Column
I am currently getting my blood tested every two weeks and have made a
simple 3d column chart with the data.
This shows the results well.
However i would like a red line showing the maximum and minimum levels
that would show the "Normal" parameters of the blood.
For instance the column for this week rises to 11.5 and the top and
bottom (Normal) parameters are 13.5 to 18 so I would like a line at
13.5 and one at 18 with my column of 11.5 over the lines.
Hope this is clear as this is one of my first attempts at charting.
--------------------------------------...compare two columns and display a third
here's the challenge:
-I need to compare 2 columns: A1:A10 and B1:B20 (different range)
-For each common value I would like to display the information contained in
a third column C1:C20
I did some research on this forum and http://www.cpearson.com/ but so far no
any help will be greatly appreciate to avoid doing it manually 2000 times.
=COUNTIF(A1:A10,B1) in C1 gives 1 if B1.value occurs in A1:A10, 0 if not.
Fill down to C10!
or =COUNTIF(A1:A10,B1) > 0 gives TRUE or FALSE respectively.
> here's the challenge:
> -I...displaying negative values
how do I hide the display of negative numbers?
Regards from Brazil
> how do I hide the display of negative numbers?
That will work if cell A1 has a formula in it.
If negative numbers are just typed in, you can use conditional formatting.
Highlight the range of cells you want to format.
Go to Format > Conditional Formatting...
Enter cell value is less than 0.
Click the Format... button and select Color: and then click the white icon.
> =if(A1<0,"&qu...running 9 and 10 on same mahine
We are currently running version 9 using SQL 2005 and Windows server 2003.
It is possible to install and run version 10 on the same machine? If so, do
I need a separate instance of SQL 2005?
Both versions are being used in a teaching environment so the normal caveats
about mission critical systems does not apply.
Dr. Jerry Flatto
University of Indianapolis
Indianapolis, IN, USA
2007 Excellence in Education Pinnacle winner
On Jul 31, 12:48 pm, Jerry Flatto
> We are currently running version 9 using SQL 2005 and Windows ser...