Re: $$Excel-Macros$$ Need to populate the data from Pivot

2011-09-19 Thread anu gomathi
Hi All, Any suggestions? Regards Shiek On Thu, Sep 8, 2011 at 10:46 PM, anu gomathi anugomathi.d...@gmail.comwrote: 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

Re: $$Excel-Macros$$ Business Reporting Templates

2011-09-14 Thread anu gomathi
, anu gomathi anugomathi.d...@gmail.comwrote: Hi All, Please send me any Business reporting Templates. Regards Anu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Need to populate the data from Pivot

2011-09-12 Thread anu gomathi
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.comwrote: Hi All, Please find the attached file. Need to populate the data sheet from pivot Regards Anu On Thu, Sep 8

Re: $$Excel-Macros$$ Add the multiple row values delete the duplicate row

2011-09-08 Thread anu gomathi
Hi, Need to add the value from X to DO column. Regards Anu On Thu, Sep 8, 2011 at 6:11 PM, dguillett1 dguille...@gmail.com wrote: Which columns need to be totaled? *From:* anu gomathi anugomathi.d...@gmail.com *Sent:* Thursday, September 08, 2011 12:14 AM *To:* excel-macros

$$Excel-Macros$$ Need to populate the data from Pivot

2011-09-08 Thread anu gomathi
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.comwrote: Hi, Attached the File Regards Anu On Wed, Sep 7, 2011 at 12:25 PM, Abhishek Jain abhishek

Re: $$Excel-Macros$$ Add the multiple row values delete the duplicate row

2011-09-08 Thread anu gomathi
Hi, Thanks a lot for the response. Regards Anu On Thu, Sep 8, 2011 at 11:10 PM, dguillett1 dguille...@gmail.com wrote: Try using datasubtotal as shown on the attached for col D *From:* anu gomathi anugomathi.d...@gmail.com *Sent:* Thursday, September 08, 2011 12:11 PM *To:* excel

$$Excel-Macros$$ Re: Delivery Status Notification (Failure)

2011-09-07 Thread anu gomathi
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

$$Excel-Macros$$ Add the multiple row values delete the duplicate row

2011-09-07 Thread anu gomathi
Hi All, Attached the sample file with the duplicate opportunity details. I need to add the values in the 1 row delete the duplicate rows. Need u r help to create macros. Regards Anu -- -- Some important links

Re: $$Excel-Macros$$ Add the multiple row values delete the duplicate row

2011-09-07 Thread anu gomathi
Hi Experts, Need your help in this. Regards Anu On Wed, Sep 7, 2011 at 11:37 PM, anu gomathi anugomathi.d...@gmail.comwrote: Hi All, Attached the sample file with the duplicate opportunity details. I need to add the values in the 1 row delete the duplicate rows. Need u r help to create

Re: $$Excel-Macros$$ Add the multiple row values delete the duplicate row

2011-09-07 Thread anu gomathi
be same campare to first row. On Thu, Sep 8, 2011 at 10:21 AM, anu gomathi anugomathi.d...@gmail.comwrote: Hi Experts, Need your help in this. Regards Anu On Wed, Sep 7, 2011 at 11:37 PM, anu gomathi anugomathi.d...@gmail.com wrote: Hi All, Attached the sample file

$$Excel-Macros$$ Help in IF Function

2011-09-06 Thread anu gomathi
Hi All, Please help me to put the IF function for the below table. If the table value is 0 the product should not be there Attached the file for u r reference Tech OFM Apps Systems Result should be 1 2 0 1 Tech;OFM;Systems 1 2 0 1 Tech;OFM;Systems 1 2 1 0 Tech;OFM;Apps 1 0 0 1 Tech Systems

Re: $$Excel-Macros$$ Help in IF Function

2011-09-06 Thread anu gomathi
Thanks a lot pawel Regards Anu On Wed, Sep 7, 2011 at 12:41 AM, pawel lupinski lupins...@yahoo.com wrote: result by IF function regards, Pawel -- *From:* anu gomathi anugomathi.d...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, September 6

Re: $$Excel-Macros$$ Need macro to split the files

2011-08-31 Thread anu gomathi
a lot for your help. Regards Anu On Wed, Aug 31, 2011 at 6:05 AM, ashish koul koul.ash...@gmail.com wrote: try the attachemnt. see if it helps save the workbook in a new folder and then run split file macro On Tue, Aug 30, 2011 at 10:22 AM, anu gomathi anugomathi.d...@gmail.comwrote

Re: $$Excel-Macros$$ Need macro to split the files

2011-08-31 Thread anu gomathi
tell me do u want to apply filter on regional lead or divisional lead. On Wed, Aug 31, 2011 at 2:29 PM, anu gomathi anugomathi.d...@gmail.comwrote: Hi Ashish, This is absolutely fantastic. Need your help to change the below things 1. Regional lead data is not populated in the Summary

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread anu gomathi
? On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote: Hi Experts, I am very new to this forum. Attached the details report the out put file. I need a macro to split the workbook as per the below condition: The detail report file should be splitted based