Home

Save history of current data

%3CLINGO-SUB%20id%3D%22lingo-sub-632677%22%20slang%3D%22en-US%22%3ESave%20history%20of%20current%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632677%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20difficulty%20with%20a%20part%20of%20a%20report%20that%20needs%20to%20be%20prepared%20every%20week%2C%20and%20I%20hope%20you%20can%20help%20me.%20I%20need%20to%20keep%20last%20week%20data%20as%20history%20and%20every%20week%20to%20add%20new%20data%20for%20the%20new%20one%20week.%20Can%20this%20be%20made%20with%20some%20formula%20or%20not%3F%20In%20the%20attachment%2C%20I've%20tried%20to%20explain%20what%20I'm%20doing.%20Data%20is%20loaded%20every%20week%20in%20column%20start%20with%20A19%20(A19%3A%20A29).%20Then%20values%20have%20to%20be%20transferred%20to%20the%20corresponding%20week%20in%20column%20F%20(F2%3A%20F11).%20Next%20week%2C%20when%20the%20new%20data%20is%20uploaded%20in%20column%20A19%20the%20new%20data%20have%20to%20be%20added%20in%20column%20G%20and%20the%20data%20in%20column%20F%20should%20stay%20as%20a%20history.%20And%20this%20has%20to%20continue%20for%20each%20subsequent%20week%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F115642i4A9ADA9A6161A7C7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22example.jpg%22%20title%3D%22example.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-632677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632805%22%20slang%3D%22en-US%22%3ERe%3A%20Save%20history%20of%20current%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632805%22%20slang%3D%22en-US%22%3EWhen%20you%20say%20you%20transfer%20data%20from%20Column%20A%20to%20Column%20F%2C%20I%20would%20like%20you%20to%20mean%3A%20Copy%20data%20in%20Column%20A%20and%20Paste%20them%20as%20Values%20in%20Column%20F.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632828%22%20slang%3D%22en-US%22%3ERe%3A%20Save%20history%20of%20current%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632828%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Thanks%20for%20your%20fast%20response.%20Unfortunately%2C%20the%20answer%20is%20no.%20Data%20in%20column%20F%20is%20uploaded%20with%20formula%20with%20the%20condition%20for%20check%20of%20the%20week%20number.%20Data%20in%20column%20A%20also%20is%20linked%20-%20it%20results%20from%20data%20from%20many%20other%20sheets%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632878%22%20slang%3D%22en-US%22%3ERe%3A%20Save%20history%20of%20current%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632878%22%20slang%3D%22en-US%22%3EWhat%20I%20suggest%20is%20that%2C%20after%20calculating%20the%20values%20in%20Column%20F%20using%20formulas%2C%20you%20Copy%20and%20Paste%20them%20as%20Values%20in%20the%20same%20cells.%20For%20example%2C%20select%20F2%3AF11%2C%20then%2C%20using%20the%20right%20button%20of%20the%20mouse%2C%20drag%20the%20right%20border%20of%20the%20selection%20to%20the%20right%20but%20immediately%20drag%20it%20to%20the%20left%20to%20return%20to%20its%20original%20location%2C%20and%20click%20Copy%20Here%20as%20Values%20Only.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633084%22%20slang%3D%22en-US%22%3ERe%3A%20Save%20history%20of%20current%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633084%22%20slang%3D%22en-US%22%3E%3CP%3EIsn't%20it%20possible%20this%20manually%20copy%20and%20paste%20values%20to%20be%20replaced%20by%20using%20a%20formula%20or%20macros%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Kremena
New Contributor

Hi, I have difficulty with a part of a report that needs to be prepared every week, and I hope you can help me. I need to keep last week data as history and every week to add new data for the new one week. Can this be made with some formula or not? In the attachment, I've tried to explain what I'm doing. Data is loaded every week in column start with A19 (A19: A29). Then values have to be transferred to the corresponding week in column F (F2: F11). Next week, when the new data is uploaded in column A19 the new data have to be added in column G and the data in column F should stay as a history. And this has to continue for each subsequent week

example.jpg

4 Replies
When you say you transfer data from Column A to Column F, I would like you to mean: Copy data in Column A and Paste them as Values in Column F.

Hi, Thanks for your fast response. Unfortunately, the answer is no. Data in column F is uploaded with formula with the condition for check of the week number. Data in column A also is linked - it results from data from many other sheets

What I suggest is that, after calculating the values in Column F using formulas, you Copy and Paste them as Values in the same cells. For example, select F2:F11, then, using the right button of the mouse, drag the right border of the selection to the right but immediately drag it to the left to return to its original location, and click Copy Here as Values Only.

Isn't it possible this manually copy and paste values to be replaced by using a formula or macros?