Forum Discussion
Using if statement
Hi, I'm really new to xl... I have a Master List with a "Category" column with 5 different categories. I want each category to automatically populate its own worksheet. And it needs to be dynamic ...
Let's say the list is on a sheet called Master List in columns A to T, with the Categories are in column C.
Create a new sheet.
Enter the following formula in A1:
=VSTACK('Master List'!A1:T1, FILTER('Master List'!A:T, 'Master List'!C:C="First Category"))
where First Category is one of the five categories.
The formula will automatically spill to as many rows as needed.
Repeat for the other four categories.
Thanks so much! This is the formula I typed based on my sheets names:
=VSTACK('Master Donors List'!A1:T1,FILTER('Master Donors List'!A:T, 'Master Donors List'!C:C="Current"))
I got back a #Calc! error
Question 1: Does it matter that I have hidden columns
Question 2: Once it is working, how can I apply it to any new rows entered on the Master list?
=VSTACK('Master Donors List'!A1:T1,FILTER('Master Donors List'!A:T, 'Master Donors List'!C:C="Current"))
I got back a #Calc! error
Question 1: Does it matter that I have hidden columns
Question 2: Once it is working, how can I apply it to any new rows entered on the Master list?