Totalling columns and repeating formulas in new entries
i'm working in excel 2003
i've tried searching this, but have come up with nothing. it seems s
basic, i'm sure i must be calling it the wrong thing or something.
in my worksheet (that's what a spreadsheet is called now, isn't it?)
enter expenses in column "e" and revenues in column "i", with the ne
gain or loss for that row (entry) showing up in column "j". i had n
problem setting that up.
the first problem i'm having is the formulas and formatting bein
copied to the next entry. some of the new entries have no value i
column "e&...How to create a single line separated by commas from a matrix?
I've the following problem.
I've a table made of several columns. Each colum represents a
characteristic regarding to a subject (e.g. Name, Surname, Home
Street, etc...). In the rows I put the different people.
I need to export these info to a format compatible with other program -
an email program-, which requires the information to be arranged in a
different way. The program needs all these data to be ordered in a
single row, with each characteristic between quotation marks, and
separated by commas, following this pattern:
"characteristic 1","characteristic ...auto fill data from cells
i would like to be able to enter text data in cells in column b on 6
different worksheets and then have a seventh worksheet that will display all
of the text data from the six different sheets on it. So, if i list 40 words
in b5 thru b45(one word per cell) on all six sheets, i would like to see all
240 words on the seventh sheet(total "catch all" sheet)
Any help would be greatly appreciatiated.
On the 7th sheet, in cell A1
fill the formula down to A40
On the 7th sheet, in cell B1
and again fill the formula down to B40
R...Separate inboxes for separate accounts
How can I separate incoming e-mail from separate e-mail
accounts into folders so I can tell where incoming mail
came from? Using Outlook 2000.
>How can I separate incoming e-mail from separate e-mail
>accounts into folders so I can tell where incoming mail
>came from? Using Outlook 2000.
I'm a novice but I just ask that question and
firstname.lastname@example.org gave me the following advice:
It is done with rules.
1st create your folders (sounds like you've done that.)
Then select Tools / rules & alerts / New Rule...
This brings up...Checking if a cell is filled up with data
I would like to write a function that checks if a cell is empty or if
it has any kind of data. The kind of datas (numbers or words or bocth)
is irrelevant. The only thing that is important is whether or not the
cell is empty. Has anyone an idea how I could write such a function?
xpucto's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23748
View this thread: http://www.excelforum.com/showthread.php?threadid=374119
Enter this f...Master image to use in separate sheets?
Does anyone know if there is a way to tell Excel to use
the same image/background for each sheet, instead of
needing to import for each one? Or is there a way to set
up a (similiar to Power Point/Master slide).
Thanks in advance,
If it's just for one workbook, I'd have a master worksheet in that workbook that
I could just copy.
If it's for lots of workbooks, I'd set up a workbook with one sheet that had
that background the way I wanted it.
Then save this workbook as a Template (let the folder default to excel's
Tnen when you rightclick on...Import data 04-19-04
I need import some documents(WORD, PDF...) into
the "annotation" table. This is a one time running utility
routine. I found that the API I need is in
microsoft.crm.platform.proxy.dll. Anyone know what I
should do next? Can I just copy the .dll to some place,
and add the reference to VB.net application?
I read on a document that I couldn't write the documents
directly to SQL server table.
...Getting external data filters
I have successfully generated queeries to import data in my spreadsheets, but I don't know if I can or how to do something. My filtering data can change because it is personnel based, so I want to know if I can generate a queery that will allow the user to define the filters without having to redo the queery every time someone moves out of the respective work section or a new person joins. Basically, can I have a data entry area for them to list employees and have a queery reference this list to sort out the new data for only those people? Is there another way to do it? I am learning a...Separating a comma separated list
Not having a great deal of experience with macros, I thought I might
see if I could pick the brains of the group.
I have to essentially break out a comma separated text string in a
single cell into a vertical list, with a reference number thrown in
for good measure.
Data I have:
1 NUMBER RESOURCE
2 101 Smith John,Jones Adam,Brown Philip,Greene Thomas
3 102 Smith John,Jackson Arthur
Needs to look like:
1 NUMBER RESOURCE
2 101 Smith John
3 101 Jones Adam
4 101 Brown Philip
5 101 Gr...$ large amount of Data.
I've been working on quite a large worksheet, and after about 5000 rows, I
realized I forget to hit F4 and $$ the referenced cells. Is there a way to
highlight a large area, and have it do the whole thing at once?
Take a look at this:
>I've been working on quite a large worksheet, and after
about 5000 rows, I
>realized I forget to hit F4 and $$ the referenced cells.
Is there a way to
>highlight a large area, and have it do the whole thing at
...unable to paste excel format data in mail body!!
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
Loosing all formatting when i try to copy & paste an excel data in email body....pls suggest a solution.
Entourage does not support the creation of rich HTML messages. You can
simply attach your spreadsheet to the email message as an attachment, or
you can, while in Excel, click on File>Send To>Mail Recipient (as HTML).
Note that this method only works if Entourage is set up as your default
On 10/02/10 8:49, Dhillon@officeformac.com wrote:
> Version: 2008 ...Keeping data current
How are others making sure your account and contact information is up to date?
Where are in the process of implementing CRM and have a number of concerns
relating to Data Protection. Is there any data protection experts out there
who could advice on any question we might have ?
...Varying data on X axis
I have a graph that includes a lot of data, it looks messy hard to see
individual points. I would like to be able to vary the amount of data
points shown at anyone time on the x axis.
I have had a look at adding a scrollbar, but I can only get that to
increase the number of points shown. I want to be able to set a limit
to the number of points shown at any one time. So if I have 1000 data
points I want to able to view points 1 - 100, then 2 - 101, 3 - 102 up
to 901 - 1000.
Hope I have explained myself properly, I appreciate any help I can get.
-----------------------...Separating strings in a field to separate fields
I have a field that consists of a string value that looks like Item1,
Item2, Item3, each item is separated by commas. I want to separate
that string value so that each item has its own field. Is there code
that will easily do this?
On Wed, 5 Dec 2007 12:08:57 -0800 (PST), email@example.com wrote:
>I have a field that consists of a string value that looks like Item1,
>Item2, Item3, each item is separated by commas. I want to separate
>that string value so that each item has its own field. Is there code
>that will easily do this?
>Thank...Data Series question #2
I have a line chart with 2 data series. One for actual balance and one for
budgeted balance. The y-axis is $ amount, the x-axis is month. There are 12
points on the x-axis. (Jan to Dec). I have 12 data points for the budgeted
balance. I'm using a dynamically named range for the # of data points for the
actual balance series based on the current accounting month. (Jan shows 1
point, Feb shows 2 points etc.)
I'm trying to add a 3rd series for Projected balance which would start where
the actual balance stops. I have another dynamically names range as the data
source. I have...Archiving data
I already have an archived file from a few years ago. It
it possible to create another archive that will just add
to that original file? Or do I just have to create
In microsoft.public.money, Brian wrote:
>I already have an archived file from a few years ago. It
>it possible to create another archive that will just add
>to that original file?
> Or do I just have to create
No. You don't really have to do that either. You *could* do neither.
>Subject: Archiving data
>From: "Brian" firstname.lastname@example.org...Launch Oulook Express Newsreader separately
I use Outlook Express as my newsreader. My problem is that in order to
access it, I need to first launch Outlook.
Is there some way I can launch the newsreader portion of OE without
launching Outlook? A command line switch or something I imagine.
I'm using Outlook XP with OE 6 on Windows XP pro.
I believe the command-line switch is /newsonly.
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"aJax&...Required field with deleted data
I have a one field continuous form that gets its data from a one-field
table. The field is unique and required. The form also has a command
“Close” button. I really have problems with the “On Event” order of things.
If a person goes to a new record and starts to enter data and then deletes
it by using the backspace or delete key and then leaves the record by 1)
clicking on another record, 2) clicking on the “Close” button or 3) presses
the “Enter” key. I get the Access error message because the field is
If the new record is blank, I want to prevent the error message an...Returning a value if data is in a large list
I think you use a IF function but I am not sure.
I have two large lists of numbers. The lists are in columns A and C with
columns B and D blank. In B, I want to insert an "X" if the number in column
A next to it is somewhere in column C. I tried =IF(A2=C:C,"X","") and
=IF(A2=C2;C1000,"X","") but they do not work. Is there a way I can do this?
I like the second way. It'll be faster for larger lists ...YAPTQ: Mixed data types in custom groups (Excel 2003)
I'm trying to get the following accomplished in Excel 2003:
I have a column in a table that keeps track of how late a form was
turned in. It can have an integer (for the number of days it was late)
or one of several text strings ("On time," "Cannot determine," "Outside
I need to be able to generate the totals for:
On time or within 7 days late,
More than 15 days
Outside report dates
It seems like it should be a straightforward procedure, where one can
specify a range of numbers, or a list of values, but I ...?-Change data series range as data is entered?
I have a chart which shows a prediction curve and an actual curve. The
prediction curve runs out until the end of a project. The actual curve
is populated as data is entered. I will be generating a number of these
charts from a datatable. I would like to plot the prediction curve for
the duration of the project (easy). I would then like to plot the
actual curve with only the existing data and not have the line drop to
the x-axis at the end. Can I put a formula in the data series "x
I hope that my description makes sense.....
---...Count cells in a column that contain dates
Column J contains dates in some cells, and text in others. I need to count
the number of cells in this one column that contains dates. How can I do
If the only cells that are in that column that are numeric (like dates), you can
(Dates are just numbers formatted nicely in excel.)
> Column J contains dates in some cells, and text in others. I need to count
> the number of cells in this one column that contains dates. How can I do
...Creating Invoice with filtered data
I have a template that is uses three sheets of data to calculate costs
and then the fourth sheet is the invoice. I would like the invoice to
automatically enter the line item costs for which there is a charge.
For example, there are four item charges that are standard for every
invoice but these come after the primary charges. The list of primary
charges may consist of one line item or ten. I have been using a
basic formula IF(ISTEXT(Quote!$B4),Quote!$B4,"") but then I have to
manually enter all of the standard charges.
I would like to enter a formula that will see that there ar...Column Heading Query
I am using Outlook 2003.
I have created an extra folder to move sent items into.
There is no 'To' column displayed.
I have been able to create a 'To' column.
But, the 'To' address of each entry is not displayed in this column.
How do I achieve this objective?
"KiwiBrian" <email@example.com> wrote in message
>I am using Outlook 2003.
> I have created an extra folder to move sent items into.
> There is no 'To' column displayed.
> I have been able to create a 'To' column.