Copy information from one sheet to another in a way that still lines up despite missing or extra lin

%3CLINGO-SUB%20id%3D%22lingo-sub-3210441%22%20slang%3D%22en-US%22%3ECopy%20information%20from%20one%20sheet%20to%20another%20in%20a%20way%20that%20still%20lines%20up%20despite%20missing%20or%20extra%20lin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3210441%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%202%20sheets%20of%20data%20that%20are%20inventory%20sheets.%20One%20sheet%20is%20updated%20and%20current%20with%20what%20%3CSTRONG%3EShould%3C%2FSTRONG%3E%20be%20in%20our%20inventory%2C%20The%20other%20sheet%20has%20an%20out-dated%20list%20of%20what%20%3CSTRONG%3EShould%3C%2FSTRONG%3E%20be%20in%20our%20inventory.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20already%20counted%20the%20physical%20amount%20of%20each%20item%20on%20the%20old%20list%20but%20as%20it%20is%20incomplete%20this%20is%20no%20good.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20transfer%20all%20the%20information%20of%20the%20items%20I%20have%20already%20counted%20to%20the%20New%20list%20without%20going%20line%20by%20line.%20A%20conventional%20copy%20and%20paste%20will%20not%20work%20because%20the%20new%20list%20has%20a%20different%20amount%20of%20line%20items%20as%20well%20as%20sorted%20slightly%20differently%20so%20the%20information%20will%20not%20match%20up.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20line%20item%20has%20a%20part%20number%2C%20a%20description%2C%20and%20a%20quantity.%20I%20was%20thinking%20about%20using%20an%20If%20formula%20to%20where%20%22If%20the%20part%20number%20on%20sheet%201(old)%20matches%20the%20part%20number%20on%20sheet%202(new)%2C%20then%20the%20value%20of%20physical%20count%20is%20the%20same%20on%20sheet%202(new)%20as%20it%20is%20on%20sheet%201(old)%22%20but%20I%20cannot%20figure%20it%20out%20or%20how%20to%20do%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%20using%20some%20kind%20of%20formula%20between%20the%20two%20sheets%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3210441%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3210544%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20information%20from%20one%20sheet%20to%20another%20in%20a%20way%20that%20still%20lines%20up%20despite%20missing%20or%20extra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3210544%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1316919%22%20target%3D%22_blank%22%3E%40Lilkuhn44%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIndeed%20there%20is%20a%20way.%20I%20recommend%20that%20you%20research%20the%20%3CSTRONG%3EVLOOKUP%3C%2FSTRONG%3E%20function.%20You%20will%20use%20the%20unique%20part%20number%20as%20the%20field%20to%20search%20for%20between%20the%20two%20sheets.%20Here's%20a%20good%20instructional%20website%20on%20the%20use%20of%20the%20VLOOKUP%20function...using%20its%20guidance%20you%20should%20be%20able%20to%20figure%20out%20how%20to%20employ%20the%20function.%20Feel%20free%20to%20come%20back%20if%20you%20seek%20additional%20help.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-vlookup-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-vlookup-function%3C%2FA%3E%3C%2FP%3E%3CP%3EYou%20could%20also%20search%20for%20YouTube%20videos%20on%20the%20VLOOKUP%20function...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi!

I have 2 sheets of data that are inventory sheets. One sheet is updated and current with what Should be in our inventory, The other sheet has an out-dated list of what Should be in our inventory.

 

I have already counted the physical amount of each item on the old list but as it is incomplete this is no good. 

 

I want to transfer all the information of the items I have already counted to the New list without going line by line. A conventional copy and paste will not work because the new list has a different amount of line items as well as sorted slightly differently so the information will not match up. 

 

Each line item has a part number, a description, and a quantity. I was thinking about using an If formula to where "If the part number on sheet 1(old) matches the part number on sheet 2(new), then the value of physical count is the same on sheet 2(new) as it is on sheet 1(old)" but I cannot figure it out or how to do it.

 

Is there a way to do this using some kind of formula between the two sheets?




1 Reply

@Lilkuhn44 

 

Indeed there is a way. I recommend that you research the VLOOKUP function. You will use the unique part number as the field to search for between the two sheets. Here's a good instructional website on the use of the VLOOKUP function...using its guidance you should be able to figure out how to employ the function. Feel free to come back if you seek additional help.

https://exceljet.net/excel-functions/excel-vlookup-function

You could also search for YouTube videos on the VLOOKUP function...