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?

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Teams - Chat History
David Gorman in Microsoft Teams on
8 Replies