SOLVED

Getting and Filtering data from multiple worksheet in the same workbook

New Contributor

I am trying to get and filter the data from one of my worksheet and transfer that specific row to another worksheet. Let's say I have a main worksheet about land and aquatic creatures with 4 columns and I want to get the data from the main worksheet and filter that to a specific worksheet. The land animal row from the main worksheet will go to the land worksheet and the aquatic animal row will go to the aquatic worksheet.

 

I'm confused on how would this be possible. Can anybody help me? Thank you. 

MAIN WORKSHEET

CJCabiles_0-1656411850859.png

 

LAND WORKSHEET

CJCabiles_1-1656411899159.png

 

AQUATIC WORKSHEET

CJCabiles_2-1656411931452.png

 

  

3 Replies
best response confirmed by CJCabiles (New Contributor)