Home

Transfer data from one worksheet to another

%3CLINGO-SUB%20id%3D%22lingo-sub-312350%22%20slang%3D%22en-US%22%3ETransfer%20data%20from%20one%20worksheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312350%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%26nbsp%3B%20I%20have%20a%20workbook%20with%20multiple%20spreadsheets.%26nbsp%3B%20On%20my%20main%20spreadsheet%2C%20I%20will%20call%20sheet%201%2C%26nbsp%3B%20I%20input%20all%20the%20data%20myself%20and%20it%20has%20columns%20A-Y.%26nbsp%3B%20What%20I%20would%20like%20to%20achieve%20is%20when%20I%20enter%2Fedit%2Fdelete%20or%20move%20a%20row%20on%20sheet%201%20that%20it%20automatically%26nbsp%3Binputs%20it%20on%20sheet%202%20but%20only%20rows%20A-E.%26nbsp%3B%20I%20need%20the%20data%20in%20both%20locations%20for%20different%20uses%20and%20cant%20figure%20out%20how%20to%20have%20it%20automatically%20transfer%20to%20the%20other%20sheet%20without%20having%20to%20copy%20and%20paste%20every%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20what%20I%20did%20do%3A%20I%20used%20the%26nbsp%3B%3D'Sheet1%202019'!K1%20formula%2C%20however%2C%20I%20found%20if%20I%20add%2Fdelete%20rows%20anywhere%20in%26nbsp%3Bsheet%201%20it%20doesn't%20automatically%20transfer%20over%20to%20sheet%202.%26nbsp%3B%20I%20have%20to%20then%20go%20into%20sheet%202%20and%20manually%20do%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20an%20example%20of%20what%20I%20am%20trying%20to%20achieve.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!%20Thanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-312350%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EWorksheet%20data%20transfer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
JaclynCrosby
Occasional Visitor

Hi all!  I have a workbook with multiple spreadsheets.  On my main spreadsheet, I will call sheet 1,  I input all the data myself and it has columns A-Y.  What I would like to achieve is when I enter/edit/delete or move a row on sheet 1 that it automatically inputs it on sheet 2 but only rows A-E.  I need the data in both locations for different uses and cant figure out how to have it automatically transfer to the other sheet without having to copy and paste every line.

 

Here is what I did do: I used the ='Sheet1 2019'!K1 formula, however, I found if I add/delete rows anywhere in sheet 1 it doesn't automatically transfer over to sheet 2.  I have to then go into sheet 2 and manually do it. 

 

I attached an example of what I am trying to achieve. 

 

Please help! Thanks!!

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