VB to get rid all formulas

[Xirom431]

Hi,
I need help with VB to get rid of formulas. Here is the scenario and the formulas in Sheet 4

Area 1
G​	H​	I​	J​	K​

Column H formula =IF(G6="","",G6)
Column I formula =IF(G6="","",G6)
Column J formula =IF(G6="","",IF(OR(H6>0,I6>0),"Open","Closed"))
Column K formula =IF(J6="","",IF(J6="Open",MAX(H6,I6),0))

The range is G6:G371. If the VB can run automatically each time the Workbook is open, that would be great. Many thanks.

​

 

[Joe4]

Every time the workbook opens?
That leads me to believe that new rows of data and formulas are being entered all the time.
I think a bit more background/detail is needed.

How exactly are data and formulas being added to the workbook?

How often does it happen?

Is it only one row added each time, and can a whole block of rows/formulas be added in a single sesssion?

 

[Xirom431]

Every time the workbook opens?
That leads me to believe that new rows of data and formulas are being entered all the time.
I think a bit more background/detail is needed.

How exactly are data and formulas being added to the workbook?

How often does it happen?

Is it only one row added each time, and can a whole block of rows/formulas be added in a single sesssion?

Everyday, data is manually enter in Column G based on today()
Currently, the formulas are copied down from H6:H371, I6:I371, etc...

 

[Joe4]

Hmmm, your request does not seem to make much sense to me.
If we convert all the formulas to hard-coded values, then there will be no formulas to copy down the next day.

We could instead just have VBA calculate those values behind the scene, and populate the values.
But let's take a step back for a minute.
Why is there a need to replace the formulas with hard-coded values?
What is the concern with leaving the formulas?