Paul , it would be really helpful if you let me know if there is any way in which we can do this : Filter a data on say Column A (column A data has 10 unique values ) first, then on Column B (But this column No. of values keep on changing, sometimes 9 , sometimes 10, 11,) and then prepare separate Sheets for each combination of Column A and Column B .
thanks Sameer On May 21, 4:05 pm, Paul Schreiner <schreiner_p...@att.net> wrote: > the technique itself is fairly simple. > the biggest issue is identifying which rows to move to which sheet. > > You said that the account number is in column "a". > is it in ALL rows for the record? > > if you can give me a sample of data, I can help put it together for you. > > Paul > > ________________________________ > From: Iain Marrs <sleepdepra...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Thu, May 20, 2010 12:58:50 PM > Subject: $$Excel-Macros$$ Help breaking out data on single worksheet to > multiple worksheets > > We have raw data sheets that deal with data for multiple client > accounts. > > There may be multiple different rows associated with a single account > number, and several thousand account numbers in total. > > The account number is in column A. > > Our goal is to take a single worksheet and break it out into multiple > worksheets, so that all rows with an instance of the same data in > column A are copied to seperate sheets. > > Does anyone know of an easy way to do this? > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
