Can anyone help?
I have a vast amount of data,from which I wish to extract only a certain type of data onto another sheet.
Example:
No. Product Code
1 toys 123
2 toys 345
3 candy 854
4 toys 585
5 clothes 586
6 candy 236
7 clothes 587...
From the list above I would like to extract just "toys" and all the information on its row onto another sheet.. also when I change/add something on the main sheet, it automatically adjusts it on the "toys" sheet.
How do I do this?
I have a vast amount of data,from which I wish to extract only a certain type of data onto another sheet.
Example:
No. Product Code
1 toys 123
2 toys 345
3 candy 854
4 toys 585
5 clothes 586
6 candy 236
7 clothes 587...
From the list above I would like to extract just "toys" and all the information on its row onto another sheet.. also when I change/add something on the main sheet, it automatically adjusts it on the "toys" sheet.
How do I do this?