Copy Data to Other Sheets' Columns Based on Criteria

[rajatds31]

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

[#2]

Hi @rajatds31

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

[#3]

I have same type result (please look on @Sergei Baklan Sir Post

(https://techcommunity.microsoft.com/t5/excel/copy-data-to-other-sheets-columns-based-on-criteria/m-p...)

[#4]

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