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 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,

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

2011-09-14 Thread anu gomathi
Hi Noorain, Thanks for the file. Please let me know any other Business reporting dashboard available Regards Anu On Wed, Sep 14, 2011 at 3:38 PM, NOORAIN ANSARI wrote: > Hi Anu, > > Please find attached sheet, if it help to u > > On Wed, Sep 14, 2011 at 3:10 PM, anu g

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 wrote: > Hi All, > > Please find the attached file. Need to populate the data sheet from pivot > > Regards > > Anu > > On T

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 wrote: > Try using data>subtotal as shown on the attached for col D > > *From:* anu gomathi > *Sent:* Thursday, September 08, 2011 12:11 PM > *To:* excel-macros@googlegroups.c

$$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 wrote: > Hi, >> >> Attached the File >> >> Regards >> >> Anu >> >> On Wed, Sep 7, 20

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 wrote: > Which columns need to be totaled? > > *From:* anu gomathi > *Sent:* Thursday, September 08, 2011 12:14 AM > *To:* excel-macros@googlegroups.com > *Subject:*

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

2011-09-07 Thread anu gomathi
e campare to first row. > > On Thu, Sep 8, 2011 at 10:21 AM, anu gomathi > wrote: > >> Hi Experts, >> >> Need your help in this. >> >> Regards >> >> Anu >> >> On Wed, Sep 7, 2011 at 11:37 PM, anu gomathi > > wrote: >> &

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 wrote: > 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

$$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 fo

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

2011-09-06 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

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 wrote: > result by IF function > > regards, > Pawel > > ---------- > *From:* anu gomathi > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, September 6, 2011 9

$$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$$ Need macro to split the files

2011-08-31 Thread anu gomathi
ould you 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 wrote: > >> Hi Ashish, >> >> This is absolutely fantastic. Need your help to change the below things >> >>

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

2011-08-31 Thread anu gomathi
ks a lot for your help. Regards Anu On Wed, Aug 31, 2011 at 6:05 AM, ashish koul 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 > wrote: >

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

2011-08-30 Thread anu gomathi
sion and Regional lead ? > > > On 30 août, 06:52, anu gomathi 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 cond