I have a spreadsheet with calculations in 22 columns in 6
sheets, that imports an external data file each day. In
an effort to save time, I've added code that pastes
formulas as values in the pertinent day's column each day
so the calculation process will not be as slow. The last
13 columns I have pasted as values after the first day is
imported because the data is 13 weeks of history and will
not change. I just wondered if there was any better way
to do this. Thanks as always for any help!