Auto change formula in cells when source is changed
Good day experts;
If specific cells have the same formula for example:
C1 = Product( A1;B1)
C16 = Product(A16;B16)
And so on ...
What formula should i write in C16, C17, ... so that:
when the formula in the source cell, C1, is changed the formulas in C16,
C17, ... would automatically change accordingly.
I tried "=C1" it does not work
Thanks in advance
> Good day experts;
> If specific cells have the same formula for example:
> C1 = Product( A1;B1)
> C16 = Product(A16;B16)
> C17= Product(A17;B17)
> And so on ...
...Linking many cells
I wish to link many cells in (e.g. A1:40) in sheet 1 to A1:A40 in sheet 2
without doing it one by one so that whaever I type in A1 sheet 1 appears in
A1 sheet 2. Please any idea?
As long as your 'from' and 'to' blocks are structured identically (eg 1
column of forty rows in your example), it's straightforward. Click in the
first 'to' cell, Sheet1!A1. Type the '=' sign, then click in the first
'from' cell, Sheet2!A1, then hit enter. Your formula in Sheet!A1 should read
=Sheet2!A1 (look for it in the formula bar). Grab the fill handle (th...Cell Reference 01-12-10
What I am looking for is that when I enter a formula (In cell B1) to pick up
value in A1. Now I need value from cell A5 in cell B2. Next value I need in
B3 is A9. Everytime I have to change the cell values manually in column B.
Formula I use : - =IF(OR(AK64<$D$4,AK64=$D$4),H331,0)
Now I need value from cell H336 and I manually change H331 to H336 shown below
Any way to make this automated.
Instead of =IF(OR(AK64<$D$4,AK64=$D$4),H331,0)
you could say
...why do i get #### in my formula cell?
I don't really know much about Excel, and my formula (it's just simple
arithmetic formulas) returns with ##### displayed on the cell, with a tooltip
showing the cell's correct value when I hover over it.
airn, make the column wider and see if that helps
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"airn" <email@example.com> wrote in message
news:C6F4DD7C-3D7D-475C-894D-0F7745735666@microso...How to paste a cells row from Excel to a PowerPoint 2003 Table row?
How to paste a row of cells from Excel to a PowerPoint 2003 Table row?
PowerPoint 2003 pastes all the row cells values in every cell in the row in
the PowerPoint table if I select the row in the PP table before the pasting.
PP pastes the row as an overlapping column if I place cursor in the first
cell of the target row before pasting.
...Duplicate email #5
I have several users who on occasion receive duplicate
emails. Some as many as four duplicates. I have checked
all settings and they seem to be correct. My email
provider doesn't seem to have an answer either.
If you are using POP3 accounts, then it is on the providers side, unless a
person in the mailing group has a setting to auto frward to that person. I
had that happen a few times for people who were on the main mailing list and
their supervisor also was forwarding them the email. Email providers NEVER
claim it is on their end I have found.
"Aaron" <anonymous@discu...Duplicate Transactions from Automatic Downloads
About a month ago, transactions that Money 2007 automatically download from
Schwab, started getting duplicated. Each time accounts were updated, I would
get all transactions that happened within the last couple of days, regardless
of whether they were downloaded before. Is this likely an issue with a
corrupt MS Money file, or a problem with the download service? Is anyone
else experiencing this, and does anybody know a solution?
Have a look at the thread started 11/15/07 titled 'Duplicate Transactions
"Re...How to show the month of the referenced cell (containing a date)
If a cell holds the date "2/1/08", what formula can I use that will
give me the following result:
"Feb - 08"
I tried =Month(a2)......but I just get the number of the month.
=TEXT(A2,"mmm - yy")
with the cell custom formatted mmm - yy
HTH. Best wishes Harald
"Dave K" <firstname.lastname@example.org> skrev i melding
> If a cell holds the date "2/1/08", what formula can I use that will
> give me the following result:
> "Feb - 08&...Conditional Formating: linking to display another cell
Hello, I am trying to make a traffic light with symbols and I've read to 'use
a separate cell for the dropdown choices, with their resulting value linked
into the formatted cell through an IF function, using the character that you
=IF someone enters '1' in B8, THEN display contents of $C$4 (will it display
font and attributes?)
=IF someone enters '2' in B8, THEN display contents of $C$5
=IF someone enters '3' in B8, THEN display contents of $C$6
But I've been reading everywhere and CF is very new to me and I need ...Cell with email address
I have a cell where I just want to record an email address. However, whenever I enter it tries to connect to Outlook, thinking I want to send an email. How can I stop this?
It shouldn't try to connect unless you click on it but you can precede the
entry with a single apostrophe or press Ctrl+Z after entry (undo) and a
second entry should stop it
Microsoft MVP - Excel
"Les" <Les@discussions.microsoft.com> wrote in message
news:9B53EE8A-A0A8-4AFD-A09F-116DDE063747@microsoft.co...How to hide duplicate records but show them once
I'm trying to weed out duplicate records but I need to show them once. I
can't figure out how to do this without alot of formatting and deleting. Can
See Chip Pearson's website for advice on dealing with dupes
> I'm trying to weed out duplicate records but I need to show them once. I
> can't figure out how to do this without alot of formatting and deleting. Can
> anyone help?
if the data is in one column, highlight the column, the select Data ->
Filter -> Advanced Filt...can I make cell "yes" equal 1, "no" equal 0
in another cell?
(remove nothere from the email address if mailing direct)
"can I make cell yes equal 1, no equa" <can I make cell "yes" equal 1, "no"
email@example.com> wrote in message
Picky but I don't think that you need the " +(A1="no")*0 " Just
=IF(AND(A1<>"yes",A1<>"no"),"&quo...Using Jet to read excel file returns blank for last cell
With VB6 I am opening an Excel file to query the contents using ADO. I am
then using the contents of the worksheet to create a format file that is used
for a bulk insert into SQL Server. We designed the program this way so that
users can use a spreadsheet to import data in any format they want and
process the data based on values set in the spreadsheet. This keeps us from
having to design new tables and format files for new record layouts which
come down pretty often. Everything works fine usually. There is just one
perculiarity that is happening with the Excel file. Sometimes, th...Find a value in cells
I have something like this :
I'm doing a max function in the number column and it returns me '5'
But, after that, I want to know the letter which corresponds to the max
How can I do that?
nicgendron's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25151
View this thread: http://www.excelforum.com/showthread.php?threadid=386417
Let's say that...Detecting Case of Text in a Cell
I know it's possible to change the case of text in a cell in Excel
using Lower, Upper and Proper, but is there a function that tells me
the current case of the text?
A user has a spreadsheet of catalogue items, some in proper case and
some in upper. He wants to seperate those in upper case into a separate
sheet but I can't think of an easy way of doing it.
Can anyone help?
Colin Vicary's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10472
View this...Getting cells to automatically delete spaces
I have got a very large spreadsheet where the information is presente
Notice the two spaces after the forward slash. There's about 10'00
cells in the column with varying numbers but all in the above format.
I need to get the two spaces deled so that it will appear as:
Is there a way i can get excel to proccess this for me.
Any help will be much appreciated.
Thanks in advance.
Message posted from http://www.ExcelForum.com
Select the required area or a whole sheet, and do a simple Replace (Edit
menu), asking Excel to replace s...Identifying LOCKED cells
Is there a way to identify locked cells, other than going through the processof
looking at each cell's format? Here's by quandry. I am working a worksheet
which has both locked and unlocked cells. Unfortunately some of the locked
cells should be unlocked so that data can be input.
Thanks for your help
To reply to this message, remove "mand" from my address. Thanks
I've dragged the lock button onto a toolbar. When I click on a cell, I can
glance at that and see if it's depressed (not suicidal!) or not.
Tools|Customize|Commands Tab|Format category.
Look for "Lo...enter value in a cell from a combo box
How to build a combo box to be able to select a value and enter in the cell
1. Go to View > Toolbars > Control Toolbox
2. Click on the "Combobox" icon once and draw one on your
worksheet (hold down the ALT button to fit to a cell).
3. Right-click on the Combobox and go to Properties.
4. In the ListFillRange type in the range of cells that
contain the values to fill the combobox, like A1:A5.
5. In the LinkedCell field type a cell reference that
will contain the user's selection (ie E2).
6. Click on the Exit Design Mode icon and close the
...paste linked cells show "0"
I have a number of cells in a range (lets say A14:J52).
Some of these cells are "paste linked" from cells on other sheets.
Unfortunately, when the original cell is empty, the value of the
"paste linked" cell shows as "0".
(not just blank like the original)
Is there a way to keep the "paste linked" cell showing "0"?
If not, how would I go about using VBA to systematically go through
the above described range and delete those zeros?
At the point I ran this code, any "0" could be deleted from the range
safely whether it ...removing duplicate values from a column
It sounds so simple that I must be overlooking the obvious answer, but I
can't seem to find a way to remove duplicate values from a column.
The case is simple: I have 600+ emailaddresses in column A, sorted
alphabetically and there's a bunch of duplicate addresses in there (some of
'em occur up to 7 times!!). Instead of manually running through the whole
list, removing the duplicates, there MUST be some soft of filter/function in
excel to do this for me... Could anyone PLEASE help me with this!?!?
NOTE: remove the spamtrap from the emailaddress
Select the em...Cell colour change automatically
Is it possible to create a formula to automatically turn a cell a given colour?
If I type the word "Yes" in a cell I would like the cell to turn red
If I type the word "No" in a cell I would like the cell to turn green
Is this possible?
If yes please recreate a formula to assist me.
Many thanks -=- dustyv
Take a look at "Conditional Formatting" in XL Help.
In article <45794F52-0D61-4B8F-8562-A3E9E6F957BE@microsoft.com>,
dustyv <firstname.lastname@example.org> wrote:
> Is it possible to create a formul...Copy cell to a new cell
I have a cell value in the format 90TN82C128004K00. I would like to copy the
first two digits to another cell i.e. 90 and follow it up with a dummy code
00CPSS00 which will be standard for all values. the new cell should have the
following value 9000CPSS00. Is there an automated function that can do this
If you data is in A1 enter in B1:
"mohd21uk" <u20517@uwe> a �crit dans le message de news:5e5292da6a2d1@uwe...
> I have a cell value in the format 90TN82C128004K00. I would like to copy
My problem is that I cannot see the $ sign in Format Cell
window when I choose the Currency format.
Even more, the cells are not changing for the currency
Thanks for any help.
Try making a custom format.
Try this one:
Message posted from http://www.ExcelForum.com/
...Cell Reference question
This is probably a simple question, but I have never seen it before.
I have been looking at some spredsheets sent by some co-workers,
trying to figure out their structure etc... and I have seen some cell
references where the reference starts with an =+'sheetname!e2
The + (plus sign) struck me as odd, I can't recall seeing that before.
Is there some significance to it?
Believe it's a "legacy" behaviour for die-hard Lotus converts <g>
The "+" is not necessary ..
Please respond in thread
xdemechanik <at>yahoo<dot&g...get cell of function
Can I somehow determine, in which column (A,B,C,...) a selfmade function
Or: Can I tell the function, placed f.e. in cell C1, to loop through the
column left (in this example B) of it?
thanks lot for help
Dim rng as Range
set rng = Application.Caller
to see the value:
> Can I somehow determine, in which column (A,B,C,...) a selfmade function
> is called?
> Or: Can I tell the function, placed f.e. in cell C1, to loop through the
> column left (in this example ...