multiplying w/o formulas

[n00bster]

Hello all!

I have run into a little bit of an issue with formulas. The idea is that I'd need to run a super-simple formula in a cell, the likes of *2

The problem is that I don't want to use a regular formula that is written in the cell, but something more in the fashion of formatting or even something else that I haven't thought of yet. The issue with a regular formula is that I'd need the result being calculated in the same cell, not in a duplicate one. The information gets there by copy-paste, overwriting the formula anyway.

I'll try to give some example - let's say a number 10 is written / pasted into cell A1. What SHOULD happen, is that the inserted number should be automatically multiplied by pre-defined number. In case the number is "2", by inserting "10" in cell A1, it should turn into "20" - in the same cell, not A2, where using a formula is obvisously super-easy.

I'm running Excel 2007 (with the possibility to upgrade to 2010 if needed). Any ideas?

Thanks in advance,
Tim

[AlKey]

You can do that without a formula:
Type number 2 in any empty cell and copy it. Highlight values in the column or row and Paste Special, Values and select multiply.
That's all.

[n00bster]

Unfortunately that's not very convenient as the cells are scattered around and selecting them all for paste special function, would be quite a hassle + additional chance to miss some. I'm looking more of a pre-set situation (hoping one exists).

[jeffreybrown]

Hi n00bster,

Seems you would need to use some code to do what you desire...

Please Login or Register  to view this content.

Paste code in a Sheet module

• Where to paste code
• Highlight macro to copy >> Ctrl + C >> Open your workbook
• Right click on sheet tab >> View Code >> opens the Visual Basic Editor (VBE)
• Ctrl + R >> opens the Project Explorer (if not already open on left side of screen)
• Paste code >> Ctrl + V (right side of screen)
• Alt + Q >> exits VBE and returns to Excel
• Now simply make a change in target cell

[n00bster]

Thanks, I'll give it a try