A
alexzagrant
Good day,
I need help. I can't seem to get anything to work. I'm a beginner
know, but I have tried the Filters using criteria, Piviot tables, an
some other things, that I probably shouldn't have been touching. S
here goes.
I have A) a large excel sheet with info, about 20 columns wide with 25
rows. So I would call this the "main database info"
B) There is a column called "names" with about 20 different names.
C) What I would like to do is: Without messing with the main database
sort out each name to a new page. but have the sort saved so it can b
constantly updated when new info is placed in the main database info.
D) And if possible I would love to be able to use a second column, sa
with the "fav food" (fruit, veg, meat, junk) and separate those ou
also. Then I would have a new sheet with each name sorted into group
of fav foods.
I can't seem to get anything to work. I either get errors or it doesn’
copy over any information. Any ideas??
Thanks,
A
I need help. I can't seem to get anything to work. I'm a beginner
know, but I have tried the Filters using criteria, Piviot tables, an
some other things, that I probably shouldn't have been touching. S
here goes.
I have A) a large excel sheet with info, about 20 columns wide with 25
rows. So I would call this the "main database info"
B) There is a column called "names" with about 20 different names.
C) What I would like to do is: Without messing with the main database
sort out each name to a new page. but have the sort saved so it can b
constantly updated when new info is placed in the main database info.
D) And if possible I would love to be able to use a second column, sa
with the "fav food" (fruit, veg, meat, junk) and separate those ou
also. Then I would have a new sheet with each name sorted into group
of fav foods.
I can't seem to get anything to work. I either get errors or it doesn’
copy over any information. Any ideas??
Thanks,
A