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
