Hi All, Any suggestions?
Regards Shiek On Thu, Sep 8, 2011 at 10:46 PM, anu gomathi <anugomathi.d...@gmail.com>wrote: > Hi All, > > Please help me with macro to populate the data from the the pivot to the > specific fields > > Regards > > Anu > > On Wed, Sep 7, 2011 at 3:17 PM, anu gomathi <anugomathi.d...@gmail.com>wrote: > >> Hi, >>> >>> Attached the File >>> >>> Regards >>> >>> Anu >>> >>> On Wed, Sep 7, 2011 at 12:25 PM, Abhishek Jain <abhishek....@gmail.com >>> >wrote: >>> >>> > Anu, >>> > >>> > A sample file will help. Please provide. >>> > >>> > AJ >>> > >>> > >>> > On Wed, Sep 7, 2011 at 12:23 PM, anu gomathi < >>> anugomathi.d...@gmail.com>wrote: >>> > >>> >> >>> >> > >>> >>> > Hi All, >>> >>> > >>> >>> > Attached the sample data. >>> >>> > >>> >>> > I have a set of data with multiple opportunity id with the product >>> >>> split >>> >>> > which is in the vertical order. >>> >>> > >>> >>> > Now i have to make the opportunity id unique & the product level 3 >>> in >>> >>> the >>> >>> > horizantal. >>> >>> > >>> >>> > I have used the pivot for this & linked to the pivot vp sheet to >>> final >>> >>> > format sheet. >>> >>> > >>> >>> > Is there any way to populate the data from the data sheet > Final >>> >>> format >>> >>> > sheet? or from pivot > final format sheet >>> >>> > >>> >>> > I have linked the the first row in the final format sheet marked in >>> >>> brown. >>> >>> > Need to populate the only the linked columns & the others should be >>> >>> left >>> >>> > blank >>> >>> > >>> >>> > Regards >>> >>> > >>> >>> > Anu >>> >>> > >>> >>> > I >>> >>> > >>> >>> >>> >> >>> >> -- >>> >> >>> >> >>> ---------------------------------------------------------------------------------- >>> >> 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 >>> >> >>> >> <><><><><><><><><><><><><><><><><><><><><><> >>> >> Like our page on facebook , Just follow below link >>> >> http://www.facebook.com/discussexcel >>> >> >>> > >>> > -- >>> > >>> > >>> ---------------------------------------------------------------------------------- >>> > 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. >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel