pasting result of formula

[Cloverken]

I have a question regarding gold prices.

I have a formula to calculate the current days price for gold and I input the amount bought for today. After the result of the formula is figured for today is there a way for it to be pasted to save the result.

Then tomorrow when gold is a different price and I have the same formula calculating the amount of ounce of gold bought with the automatic price per ounce of gold retrieved from the Internet. Then it would paste tomorrow result for tomorrows quote.

Hopefully I am clear on this.

Thanks
Ken

 

[DRJ]

You can use this:

    Range("A1").Copy
    Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False

 

[Yogi Anand]

Hi Cloverken:

Let us look at the following non-macro solution using DATA|Validation ...

Book1
	A	B	C	D	E
1		CellB2IsDataValidatedList=D2		FormulaForToday'sGoldPriceInCellD2
2		345.50		$345.50
3
Sheet1

Would this work for you!