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
Last edited by katani; 07-28-2011 at 10:52 AM. Reason: as per forum rules
Welcome to the forum.
Please take a few minutes to read the forum rules, and then amend your thread title accordingly.
Thanks.
Entia non sunt multiplicanda sine necessitate
I didn't see a link in SHG's post above, (this is on the menu bar above, but since you're new) so this should help:
the Forum Rules
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Sorry for this.
As it is my first post so I did it without reading the ruls.
Sorry again.
I will repost my request using another subject
Thanks
Katani
Don't break a second rule by double posting. EDIT the first post in this thread, GO ADVANCED and edit the title.
Sorry again as the second rule has already broken by mistake.
Katani
Please continue in the new thread after you've read the forum rules.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks