Forum Discussion
I'm trying to autofill information to different tabs from a master list
Hello, Please assist, I have a master listing with 24 columns. This is the main tab on my doc. What I am trying to accomplish is to have the information autofill into 1 of the other tabs based on ...
If you have Microsoft 365 or Office 2021 (or use Excel Online), you can use the FILTER function. It would look like this:
=FILTER('Master List'!A2:X1000, 'Master List'!B2:B1000="Location 1", "")
where Master List is the name of the master sheet, and Location 1 is the name of one of the locations.
Perfect, thank you!!
