Hi All, Need your help to Populate the data from the pivot for the available columns.
Regards Anu On Thu, Sep 8, 2011 at 10:57 PM, anu gomathi <anugomathi.d...@gmail.com>wrote: > Hi All, > > Please find the attached file. Need to populate the data sheet from pivot > > Regards > > Anu > > 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