Paul, Someone at work was able to create the excel add in we needed for this. Thank you for offering your assistance.
On Mon, May 24, 2010 at 4:50 AM, Paul Schreiner <schreiner_p...@att.net>wrote: > so... you're wanting the data copied to new WORKBOOKS not sheets (as you > said in your first message) > makes sense. > > I'll see what I can do. > > basing it on a specific column is fairly easy. > > what I'll do is sort it by column A, then copy the data to a new workbook > until the value in "A" changes. > > > I've got to run to a doctor's appointment. I'll see what I can do when I > return. > > Paul > > ------------------------------ > *From:* Iain Marrs <sleepdepra...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Fri, May 21, 2010 2:03:25 PM > *Subject:* Re: $$Excel-Macros$$ Help breaking out data on single worksheet > to multiple worksheets > > Thanks Paul, > > Here are two examples of how we would use it. We typically base it on the > data in column A, but being able to indicate what column we wanted would be > exciting as there are multiple data points we might try to break data out > by, like tier, or task type or > > First is keywords and ads we would break out typcially by campaign name > (col A). Second is data based on Account ids, but again, use case could be > such that we would want data broken out by Tier or Task Type. > > Since we are aligned with mulptiple sub groups, rather than send out a > large sheet and have the subgroups sfit through it for the information > pertinent to them, we want to send them sheets specific to their > organization. I was looking for a way that was easier than simply filtering > and copying to new WB > > On Fri, May 21, 2010 at 4:05 AM, 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 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 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 at >> http://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 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 at >> http://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 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 at > http://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 > -- ---------------------------------------------------------------------------------- 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
