Copy Data not Formula

  • Thread starter Thread starter Rick Kasten
  • Start date Start date
R

Rick Kasten

I have a monthly spreadsheet data that I wish to add to a yearly
spreadsheet. I want the yearly data to update automatically when monthly
data is added, and I know how to do cell formulas like =Monthly!D11 to get
that. However, on the first of the next month, I want to have all that data
from the previous month to be static. I think what I am asking for is to
have all the March data in the yearly spreadsheet to be the actual resulting
numbers in the needed columns of the March monthly spreadsheet, not the cell
formulas that copied the data over. If I continue to use the cell formulas,
and I clean out my monthly spreadsheet for April, all my March data in the
yearly spreadsheet goes away.

I hope I was clear in that question. How do I set up my yearly spreadsheet
the way I need it to be?

Rick
 
Before you clear that data, convert your formulas to values???

Select your range (no more than you need!)
edit|copy
edit|paste special|Values
 
Before you clear that data, convert your formulas to values???

Select your range (no more than you need!)
edit|copy
edit|paste special|Values
Click to expand...

Has anyone else noticed (circa 2014) that the menu item for "paste special > values only" is still there, but now we're getting notices like "press ctrl + v instead, copy and paste from the edit menu isn't supported anymore"?
(e-mail address removed)
 
Back
Top