Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Update a cell

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Update a cell

Reply to Message Icon

Name: KRS
Date: September 15, 2009 at 08:28:09 Pacific
OS: Windows XP
Product: Microsoft Excel 2007
Subcategory: OpenOffice.org
Comment:

How do I update a cell with the results of a formula from another cell. I do not want to place a formula in cell one - just the results from another cell.



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: September 15, 2009 at 09:28:27 Pacific
Reply:

There are 2 ways to set one cell equal to another cell:

1 - With a formula: e.g. in B1 enter =A1
2 - With a Macro: Range("B1") = Range("A1")

OK, 3 ways...

3 - Type the value into B1 manually.

If you don't like option 1, you'll have to use 2 (or 3).



0

Response Number 2
Name: KRS
Date: September 15, 2009 at 12:55:24 Pacific
Reply:

Thanks! Number 2 works for me.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: Update a cell
Hyperlink w/Sort by clicking a cell www.computing.net/answers/office/hyperlink-wsort-by-clicking-a-cell/3600.html

detecting ANY character in a cell www.computing.net/answers/office/detecting-any-character-in-a-cell/3101.html

Replace word with value of a cell www.computing.net/answers/office/replace-word-with-value-of-a-cell/7505.html