Copy Data to Other Sheets' Columns Based on Criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-1208142%22%20slang%3D%22en-US%22%3ECopy%20Data%20to%20Other%20Sheets'%20Columns%20Based%20on%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208142%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20I%20Have%20all%20crossing%20sheet%20and%20type%20crossing%20sheets%20(NH%20%2F%20Asphalted%20Road%20%26amp%3B%20Concrete%20Road%20%2F%20Canal%20%26amp%3B%20Nala).%26nbsp%3B%20I%20would%20like%20to%20crossing%20type%20wise%20extract%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20there%20a%20formula(s)%20that%20makes%20this%20possible%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20for%20my%20bad%20English%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1208142%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208224%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20Data%20to%20Other%20Sheets'%20Columns%20Based%20on%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208224%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F565603%22%20target%3D%22_blank%22%3E%40rajatds31%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20understood%20your%20requirement.%20Please%20take%20a%20look%20at%20attached%20file%20and%20let%20me%20know%20if%20this%20does%20the%20job%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208755%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20Data%20to%20Other%20Sheets'%20Columns%20Based%20on%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208755%22%20slang%3D%22en-US%22%3EI%20have%20same%20type%20result%20(please%20look%20on%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%20Sir%20Post%3CBR%20%2F%3E%3CBR%20%2F%3E(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fcopy-data-to-other-sheets-columns-based-on-criteria%2Fm-p%2F109801%2Fhighlight%2Ffalse%23M11123%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fcopy-data-to-other-sheets-columns-based-on-criteria%2Fm-p%2F109801%2Fhighlight%2Ffalse%23M11123%3C%2FA%3E)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2172678%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20Data%20to%20Other%20Sheets'%20Columns%20Based%20on%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2172678%22%20slang%3D%22en-US%22%3EIs%20there%20anyone%20still%20replying%20to%20this%20thread%3F%20Looking%20for%20help%20with%20creating%20a%20double%20entry%20accounting%20workbook.%20I%20have%20tables%20set%20up%2C%20all%20tabs%20ready%20to%20go%2C%20but%20I%20can%20not%20figure%20out%20how%20to%20get%20the%20data%20from%20sheet%20x%20to%20transfer%20to%20appropriate%20sheets%201-20%20based%20on%20account%20title.%20I%20would%20add%20a%20link%20but%20am%20having%20trouble%20saving%20a%20copy%20to%20cloud%20to%20share%20link%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

          I Have all crossing sheet and type crossing sheets (NH / Asphalted Road & Concrete Road / Canal & Nala).  I would like to crossing type wise extract .

 

Is there a formula(s) that makes this possible?

 

Sorry for my bad English

 

Please see attached file

3 Replies

Hi @rajatds31

 

I hope I understood your requirement. Please take a look at attached file and let me know if this does the job 

Is there anyone still replying to this thread? Looking for help with creating a double entry accounting workbook. I have tables set up, all tabs ready to go, but I can not figure out how to get the data from sheet x to transfer to appropriate sheets 1-20 based on account title. I would add a link but am having trouble saving a copy to cloud to share link