I understand now how the macros work. Thanks so much. It's great! Nadine
________________________________ From: Sandeep Kumar Maurya <sandymau...@gmail.com> To: excel-macros@googlegroups.com Sent: Sun, July 25, 2010 10:48:42 AM Subject: Re: $$Excel-Macros$$ Need list style from data Macro Name Purpose CreateList1 create list as per all items and place them in Solution sheet starting from A2 CreateList2 create list as per given cost/price and don't include blank cells. This is also in Solution Sheet starting from cell A2 Why you can't see the difference which is blank cost values for some item ( If I'm correct ). Did you enable the macro for this file? What these macro needed. A worksheet named "Data" for data source with same format as given in your file. A worksheet named "Solution" for your list. Note: These macro deletes everything from cells A2:E65536 and then put the list. You can extend Items and Rows in "Data" sheet. Thanks & Regards Sandeep On Sun, Jul 25, 2010 at 7:39 PM, Nadine S <n8dine4ma...@yahoo.com> wrote: > When I run either macro I don't see anything different. So I can't tell if > it's working. Also, how do I put this macro into my original file? I just > sent a sample. Thanks. > > ________________________________ > From: Sandeep Kumar Maurya <sandymau...@gmail.com> > To: excel-macros@googlegroups.com > Sent: Sat, July 24, 2010 3:57:17 AM > Subject: Re: $$Excel-Macros$$ Need list style from data > > Hi Nadine > > See the attached file it has two macros as you needed. > > Thanks & Regards > Sandeep > > On Sat, Jul 24, 2010 at 12:53 AM, Nadine S <n8dine4ma...@yahoo.com> wrote: >> Hi all, >> >> I have attached a spreadsheet that shows list data to the left but then >> under the Item numbers is the amount of reach combo in the list and item >> number. I would like the data in list format instead of pivot table style >> format. The result I'd like to see is included in the worksbook with 2 >> different solution options. >> >> Thanks. >> >> Nadine >> >> -- >> >>---------------------------------------------------------------------------------- >>- >> 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 > > -- >---------------------------------------------------------------------------------- >- > 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 -- ---------------------------------------------------------------------------------- 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
