Dear everybody,
I have a master sheet with many columns, names and numbers. one of the columns will read either 0,1,2, or any number above 2 (according to a function).
I need to make 4 new sheets in which the first sheet will copy all rows that read 0, the second sheet should copy all rows that reads 1, the third sheet will read 2...etc.
Many thanks in advance
Katani
could you post an example spreadsheet?
Hi katani
find the attatch file with formula
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
the file in previous post will not open in excel 2003. take the file attach with this post
try something along these lines
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you all.
Examples you posted will help me alot
Katani
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks