"Freeze" the results in a table with a formula
Posted on 2011-03-10
could you please suggest a "best solution" for the following requirement?
Maybe there is a built in command/function which I do not know, maybe this requires manual work (copy and past) maybe a simple macro on button push will solve it....
I have monthly data import in sheet1. I do not want to have 12 sheets, so I thought I have sheet1 called data-import and copy from another source once a month data to that place.
On sheet2 etc. I have reports which take and summaries respectively from that data by month.
The point is now that the results get lost from February as soon I will copy the data from March.
So I'm looking for clever solution to "freeze" the data in the February column on sheet2 by button click on top of the column or by a formula or command. Actually I need to keep the values but need to get rid of the formula activity.
So next month I copy March data, Feb results will be kept in the table and March is added.
Currently I use the copy and paste value manual method to a second "result table" but I'm sure there is a better solution out.
thanks for suggestions and help