Addition function of multiple cells
Does anyone know if there is a function that will take a list of numbers in
different cells and run various addition combinations on the list to detemine
which cells will add to a specific number? For example:
A1 = 1
A2 = 2
A3 = 5
A4 = 7
I want to know which cells added to gether will give me 6...answer = A1 + A3
On Tue, 25 May 2010 11:11:01 -0700, DB74
>Does anyone know if there is a function that will take a list of numbers in
>different cells and run various addition combinations on the list to detemine
>which ce...Automatically up date time in a cell
I can enter the time in a cell by using the =now() and can update it by
hitting the F9 key but how can I make it change automatically to always
remain the same as the computer clock. I would imagine I need a macro to do
it ...can someone please help me.
check this thread....
"Mark" <Mark@discussions.microsoft.com> wrote in message
> Hi all,
> I can enter the time in a cell by using the =now() and can update it by
> hittin...How to sort number follow cell accordingly
I need to create macro that can sort numbers as below:
Column : Before
A B C D E F
1 2 3 4 5 6
3 4 5
1 3 4 5
3 5 6
A B C D E F
1 2 3 4 5 6
3 4 5
1 3 4 5
3 5 6
which mean same number follow the same column but not necessary follow
Pls help with vba code.Thanks
You have to evaluate the assumptions in the program (i.e. read the comments
and evaluate the code). Basically, Integers are assumed for the sort, and
the Integers start at 1 and each...Running Sum of cell in many spreadsheets
I have a workbook that is comprised of daily bank deposits. Each worksheet
has a cell H3 that has the total money collected. I would like to create a
worksheet that will add the value in every H3 cell in the workbook. The
formula must capture all worksheets in the workbook as they are added. In
other words, I'd like a total of deposits for the year on an ongoing basis.
Can you also create a graph of the totals by month? The tab on each
worksheet reflects the date of the deposit (Mar 8 2010) or (Mar 5-6 2010).
Insert two new sheets, and name one of them "start&qu...Data Validation on Cells #2
How can I restraint the user from entering odd numbers in the cell? But I need the outcome to be in multiples of 5?
So you want to restrict entries to even multiples of 5?
Assuming your input cell is A1:
In article <1F69353E-81F6-4D95-A901-5550AEB042E3@microsoft.com>,
ringo tan <ringo email@example.com> wrote:
> How can I restraint the user from entering odd numbers in the cell? But I
> need the outcome to be in multiples of 5?
> Ringo Tan
or do you, once the perso...fill all cells in row with one cell entry
I have a range of cells and in that range If I enter any type of text/number
I want the rest of the row that cell belongs to, to be blacked out or marked
somehow to show that, that row has an entry in it already. Is this possible.
Please help. thank you.
>I have a range of cells and in that range If I enter any type of
> I want the rest of the row that cell belongs to, to be blacked out or
> somehow to show that, that row has an entry in it already. Is this
Assume range is A1:D5
Select A1:D5 (with A1 ac...How to populate a bunch of cells at once
My spreadsheet is huge and I would like the user to be able to populate an
entire chunck of cells in the colum based on some criteria.
So, if the user enters a value in one cell, a prompt could come up and ask
"would you like to populate all the cells with this value that have the
color red as the key" etc etc.
Please give me a hint as to how to go about it. Once I get the idea, I will
Thanks so much
maybe not what you're looking for, but:
- select all desired cells
- enter your value
- finish the entry with CTRL+ENTER (not with a single ENTER)
Frank...Extracting the data according the number of cell (at specific range) #2
I have a minor Excel formula problem.
In my example has following data, cell A5 shows "apple", A6 shows "salt", A7
shows "sugar" and A8 shows "fish". On another hand, cell B3 is the
"criteria" data showing 3. My question is to form an Excel formula which can
extract the data from cell "A1" and then extract the 3rd data, which is
"sugar" (that is the result I want).
Althought the formula is counting from A1, but the excel formula know the
data after "apple" and "salt" is "sugar" (cell fro...Still need help
The subroutine did not run as I received the Macro Disabled message. I
clicked OK, and next time I opened the workbook, I didn't get the Macro
Warning, but the subroutine apparently didn't run as the chosen cells were
I don't want people who use my workbook to have to deal with macro warnings.
Is this something that must be set on each user's computer, or can I set it
in my workbook so the subroutine automatically runs on everyone's computer?
Do I need to get a Certificate?
Here's my code. Are the () and the " " necessary? I'm...Cell Location
Does Excel have a way of highlighting whatever cell I am in. Particularly
with spreadsheets with lots of data, it would be easier on my eyes if what
ever cell I am currently in is somehow highlighted and when I deselect it
goes back to normal. It would be even better if the entire row and column
would highlight. Please let me know if this is a function that is available
on Excel. thanks
there are several good sugestions at
> Does Excel have a way of highlighting whatever cell I am in. Part...How to copy "edge" formatting to other cells.
I spent a long time formatting the edges of the cells in my document,
now the document looks like a table that I would like to use a template.
a) Is there a way to copy only this formatting [not the values in the
cells] and paste it to other cells? [i.e., create new templates]
b) Is there a way to paste values INTO a blank template [that has the
correct formatting of the edges of all of the cells, but no values in the
cells], keep the formatting of the edges of the cells?
On Wed, 20 Jul 2005 16:45:06 -0700, Sam wrote:
>I spent a long time formatting the edges o...Pictures in Cells
I teach elementary computers, and I often make my own online worksheets
for the kids. I am making an "ABC Order" sheet where I have pictures of
animals in one column and pictures of animal names (as opposed to just
typing the names in the cells) in another column. The kids will slide the
names into alphabetical order, then slide the picture of the animal next to
My question is this; is there a way to "protect" or "lock" the pictures
so that the kids can move them but not accidentally resize them? I have
tried every combination of loc...Adding within a cell
I'm adding to the same cell continouslythroughout my worksheet. Can I keep entering data within a cell and have it add on its own without having to add in my head and change the cell each time??
Take a look at
In article <4111F0B3-FD66-41DB-ADDA-89BD4C022139@microsoft.com>,
"Rosa" <Comoestanohay@aol.com> wrote:
> I'm adding to the same cell continouslythroughout my worksheet. Can I keep
> entering data within a cell and have it add on its own without having to add
> in my head and change the ce...Excel 2003 SP2 Cells text color pbs
I have a problem with excel 2003 sp2: When I tape a text in cells, and after
I colorize this text in RED for exemple and put enter, my cells sem to be
red. But if I put pagedown touch on this sheet to write other cell and push
pageup my cell was blue on the screen. If I print my sheet the text of the
blue cell was red !!!!!!!!
This problem seem to work only when the police is in bold !!!!!
Have you see the same problem for other user ???? Have you a solution ??
...How to stop toolbar drop box of entire cell contents
I keep getting a drop box in the toolbar that shows my entire cell contents
and covers 1/4 of my screen. Would like it not to do that. What should I do?
That is the formula bar you see expanding.
Don't select any cells with great amounts of text or just don't display the
View>Formula Bar...........uncheck it.
That's one thing I like about Excel 2007. The option to expand or not.
Gord Dibben MS Excel MVP
On Fri, 30 Apr 2010 08:27:04 -0700, cubanmamma
>I keep getting a drop box in t...Working with cell borders
I'm trying to have a vertical inside border in one cell, and that choice does
not seem to be available, i.e., it's grayed out on the borders box. Why is
On 21 Jan, 13:26, neppyworker <neppywor...@discussions.microsoft.com>
> I'm trying to have a vertical inside border in one cell, and that choice does
> not seem to be available, i.e., it's grayed out on the borders box. Why is
The inside border option refers to when you are working with a range
of cells. If you selected A1:B3, and chose the inside border option,
the broder wou...get the active color of a cell
I got cells that had there color chaging automatically using a format
condition (cond#1:red if B4<10 cond#2:green if C5>100 for example...).
Now, I would like to automatically change the color to blue if the
active color is red (condition #1 true in my example).
I can get the ColorIndex of the cell:
-when no condition applied = .Font.ColorIndex
-when condition #1 applied = .FormatConditions(1).Font.ColorIndex
-when condition #2 applied = .FormatConditions(2).Font.ColorIndex
But impossible to retrieve the actual cell color... any idea?
Another way to solve my problem would be to be able ...Increment a number based on four adjoing cells
I am using an xlsx spreadsheet for indexing metadata for file folders. Based
on the metadata selected from dropdowns in columns H, I & J, the spreadsheet
builds a file number in the format AA-AA-NN-nnnnn (A=alpha; N=predetermined
number; nnnnn= sequential number).
I'm using the following formulas:
Col B =VLOOKUP(H577,FUNCTIONLU,2)
Col C =VLOOKUP(I577,CATEGORYLU,2)
Col D =VLOOKUP(J577,TYPELU,2)
=IF(D576="","",IF(COUNTIF($D$2:$D576,$D576)=1,TEXT(0,"00001")+0,IF(COUNTIF($D$2:$D576,D576)>1,INDEX($E$2:$E576,MATCH($D576,$D$2:$...VLOOKUP formula displays in cell, will not return data
I had an older version of Excel (97 maybe?) and our office updated to 2007.
Now my vlookup will not return data. The vlookup formula appears in the
cell or I get the NA#. I've formatted my lookup cells and table to General
but still get the same result.
After formatting the cell as General, re-enter it (F2/Enter) - if you're
still seeing the formula, press Ctrl/~ -- you're looking at the formula layer
instead of the value layer.
> I had an older version of Excel (97 maybe?) and our office updated to 2007.
> Now my vloo...How can i copy a value in a cell from a sheet and paste in anothe.
I ask my question with an exemple :
I want to copy a value in C2 from sheet1 to D5 on sheet2.
But , if i modify C2 on sheet1, D5 sheet2 has to be modified too.
Do you know the function to do that?
( Sorry for my bad english, i speak french usually )
Try putting this in D5 on sheet2:
Maybe this is what you want.
use the formula
"clapton" <firstname.lastname@example.org> schrieb im Newsbeitrag
&...Cell Format Question
Is there a way to format a cell, so that I can just enter a number without
having to manually enter a decimal point at the end?
I believe that I've tried it every which way, and it just doesn't happen.
For instance, I'll use the "Number" format, then specify 0 decimal points,
type in "20", and it'll just say "0" (meaning, less than one half). Can I
just enter "20", and have it appear as "20"?
I only need to enter whole numbers in these cells. I know that it's easy
enough to just type the decimal point at the end, but am ...clicking on a cell to have it add a number
Is there a way to click on a cell and have it put in a "1" the first time you
click, and then if you click it again have it put in a "2" and so on?
We do surveys in houses and need to count for example the number of chairs.
So, if we have a cell that says "chairs" and next to it the place to put the
number of chairs, we want to be able to click on the blank cell and have it
include the number of chairs, one for each click.
Is this possible and how would you do it?
Thanks for your help.
Check out the use of a SPINNER. You can go up or down, just in case y...VBA copy cell to another worksheet
Hello, I am trying to copy text information from one worksheet to
I open only the first sheet then I have a comand button by where I
want to say transfer the values.
La macro give an error at ObjWorshett.Cells(Riga, 1).text =
Errore di run-time '1004'.
Errore definito dall'applicazione o dall'oggetto.
Thanks in advance!
Dim oDO As New DataObject
Dim ObjWorshett As Worksheet
Dim strNomeFile As String
strNomeFile = "\\srv01\Dp\ANTONELLA\sblocco.xls"
Set ObjWorshett = Appli...Importing text to chart based on link to cell
I am attempting to link a cell from my spread sheet to a
text box in my chart, but have been unable to do so. Does
anyone know how or if this is possible.
On Fri, 7 Nov 2003 12:59:29 -0800, Stephen <email@example.com=
> I am attempting to link a cell from my spread sheet to a
> text box in my chart, but have been unable to do so. Does
> anyone know how or if this is possible.
Select the chart, then click in the formula bar (above the chart, next t=
the little "fx"), type the equal sign, then click on the cell that you =
wish to refe...Macro on cell content
this must be a common problem, and I thought I found the solution, but
it doesn't work ... I'm probably missing something very simple.
I want to execute a simple VB function in one cell, taking another cell
as Parameter. Both, parameter cell and function result are strings. For
A1: "this is content of cell A1"
and Convert is a VB function
Function Convert(content As string) as String
' do something depending on content
Convert = "result-string"
However, I always get a #NAME? Error in cell A2.