data transfer between workbooks confused

%3CLINGO-SUB%20id%3D%22lingo-sub-2332994%22%20slang%3D%22en-US%22%3Edata%20transfer%20between%20workbooks%20confused%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332994%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20here%20and%20not%20sure%20if%20this%20is%20the%20right%20area%20for%20my%20question%20however.%20I%20don't%20understand%20what%20macros%20or%20vbas%20are%20or%20do.%3C%2FP%3E%3CP%3EMy%20issue%20i%20need%20help%20with%20is%20that%20I%20have%20set%20up%202%20workbooks%2C%20(%20workbook%201%20is%20ALL%20ENQUIRYS)%2C%20all%20my%20customer%20contact%20is%20logged%20into%20this%20spreadsheet.%26nbsp%3B%3C%2FP%3E%3CP%3Eshould%20a%20booking%20be%20confirmed%20in%20this%20spreadsheet%20i%20want%20the%20customers%20information%20to%20be%20automatically%20duplicated%20into%20workbook%202%20(CONFIRMED%20BOOKINGS).%20rather%20than%20retyping%20all%20the%20information%20out%20again%20or%20using%20copy%20and%20paste%2C%20this%20is%20the%20part%20I%20am%20stuck%20with%2C%20i%20dont%20know%20how%20to%20connect%20the%20two%20workbooks%3C%2FP%3E%3CP%3EI%20have%20used%20conditional%20formatting%20to%20colour%20code%20the%20line(s)%20of%20information%20when%20Y%20is%20inputted%20into%20a%20column%20that%20asks%20the%20question%20%22confirmed%20booking%20y%2Fn.%3C%2FP%3E%3CP%3EI%20understand%20a%20little%20about%20formulas%20but%20don't%20understand%20anything%20about%20vba%20or%20macro%20which%20ive%20seen%20knocking%20about%20in%20youtube.%3C%2FP%3E%3CP%3EAny%20help%20and%20advice%20would%20be%20greatly%20appreciated%20but%20please%20be%20gentle%20i%20am%20rather%20new%20at%20excel%20but%20so%20love%20its%20power.%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2332994%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339478%22%20slang%3D%22en-US%22%3ERe%3A%20data%20transfer%20between%20workbooks%20confused%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339478%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047292%22%20target%3D%22_blank%22%3E%40leebez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20sample%20data%20would%20be%20appreciated%20if%20you%20need%20help%20with%20your%20solution.%26nbsp%3B%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am new here and not sure if this is the right area for my question however. I don't understand what macros or vbas are or do.

My issue i need help with is that I have set up 2 workbooks, ( workbook 1 is ALL ENQUIRYS), all my customer contact is logged into this spreadsheet. 

should a booking be confirmed in this spreadsheet i want the customers information to be automatically duplicated into workbook 2 (CONFIRMED BOOKINGS). rather than retyping all the information out again or using copy and paste, this is the part I am stuck with, i dont know how to connect the two workbooks

I have used conditional formatting to colour code the line(s) of information when Y is inputted into a column that asks the question "confirmed booking y/n.

I understand a little about formulas but don't understand anything about vba or macro which ive seen knocking about in youtube.

Any help and advice would be greatly appreciated but please be gentle i am rather new at excel but so love its power.

Thanks in advance

1 Reply

@leebez 

 

A sample data would be appreciated if you need help with your solution.  Thank you.

 

You can use VLOOKUP FUNCTION. See Sample File.