Forum Discussion
CJCabiles
Jun 28, 2022Copper Contributor
Getting and Filtering data from multiple worksheet in the same workbook
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
LAND WORKSHEET
AQUATIC WORKSHEET
As variant you may use FILTER function (microsoft.com)
3 Replies
- SergeiBaklanDiamond Contributor
As variant you may use FILTER function (microsoft.com)
- CJCabilesCopper ContributorIt is working. Thank you!
- SergeiBaklanDiamond Contributor
CJCabiles , you are welcome