Give me sample file with few rows Thanks & Regards Sandeep
On Mon, Jul 26, 2010 at 8:01 PM, Nadine S <n8dine4ma...@yahoo.com> wrote: > Can you help me again? I've loaded all my data and I have 3549 rows and > columns A-Y. All column headers are the same except Col Y = Adjustment. > When I try to run the second macro it doesn't work. I don't know how to > debug it. > Thanks. > 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 > -- ---------------------------------------------------------------------------------- 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
