Could anyone please help me with the code to do this at all?????

Many thanks

Justin

"steve_doc" wrote:

Hi

Just to answer a few of your questions, and provide a possible direction.

Using Programming Code (VBA) a macro is Created in the Worksheet_Open event
to transfer yesterdays data into the required column (Col A) and (Col B) is
cleared for todays input - very possible and not too hard!

To retain the minimum value that that product has ever reached would require
data (in some form).

The following is just a suggestion

in a workbook on sheet1 = Daily Task sheet
ColA = ProductName(or however you want to Identify the product)
ColB = YesterdaysPrice
ColC = CurrentPrice
ColE = LowestPriceToDate

On opening the workbook, ColC is Pasted to ColB
and the macro compares the yesterdays Price to the Lowest Price, If Lower
updates the Lowest Price , else leaves it as is.

Hope this answers your questions




"Rainbow-Lentil" wrote:

Hi there- trying to create a spreadsheet to track drug prices for prescribing
use.

I am using 2 columns- one to be blank to enter the currents day's prices,
and another one to show the previous day's prices.

2 questions....

1) Is there any way to set something up so that when I start the program,
the data from the previous day's "current" column transfers itself to the
"previous" column to give me a clear colum to enter the new day's current
prices???

2) Is there a function or way of retaining the minimum value EVER reached
from these sets of values being entered

Basically i want to enter the prices every day, but achieve a column that
records the "best price" ever reached. I do not want to be building up the
price change data from each days prices, as the sheet will become massive
with some 150 drugs potentially changing price every day

Hope this makes sense