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!!