converting cell formulas to into VB
 

i have many complex spreadsheets that contain thousands of rows of data. i
have created one that extracts all the data i need from all the right places
and puts it into a neater more precise format so i can work with it easily.
however because i have done this using only formulas on the spreadsheet
(thousands of of complicated ones running the length and breadth of the page)
my computer slows right down and whenever i alter anything in the workbook it
takes a very long time to respond. is it possible to instaed of having all
these formulas in the cells, program the cells with macros and VB so you dont
actually see the formula in the cell, the result just appears without using
all the memory? or is there any better suggestions? help would be much obliged

tom