Automatin a calvulatiopn in excel

[JoeJTaylor]

I have a table that data is imported to every evening using a script. However i want to do a calculation automatically when the table is opened. Comparing two cells and displaying the hishest number. I have the calculation but was wondering if there is any way to automate the updating of records whenever the file is accessed? Also would it be possible to create the row with a column at the end with this frmula in after the table had been created?

 

[SkipVought]

Hi,

"I have a table that data is imported to ..."

Is this a new workbook that is created every day?

Please be CLEAR, CONCISE & COMPLETE.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[JoeJTaylor]

Yes the table is created during the overnight run

 

[SkipVought]

The WORKBOOK is created each night, containing a table of data.

Does the workbook name change each time it is created?

I'd suggest using MS query in a new workbook, to open the data each day and perform whatever calculations you want.

faq68-5829

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}