Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

2011-07-05 Thread shannu shannu
Congrats Ashish, now dont fly our expectation has now  increased more.    --- On Tue, 7/5/11, Vasant vasant...@gmail.com wrote: From: Vasant vasant...@gmail.com Subject: Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :) To: excel-macros@googlegroups.com Date:

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

2011-04-05 Thread shannu shannu
Congrats Ashish. --- On Mon, 4/4/11, mrinal saha mris...@gmail.com wrote: From: mrinal saha mris...@gmail.com Subject: Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011 To: excel-macros@googlegroups.com Date: Monday, April 4, 2011, 10:25 AM Ashish, You are doing such a

RE: $$Excel-Macros$$ How to consolidate the data using macro

2011-02-13 Thread shannu shannu
any success. :-( --- On Fri, 2/11/11, shannu shannu shannur...@yahoo.com wrote: From: shannu shannu shannur...@yahoo.com Subject: RE: $$Excel-Macros$$ How to consolidate the data using macro To: excel-macros@googlegroups.com Date: Friday, February 11, 2011, 4:51 PM one of the beautifull

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-02-11 Thread shannu shannu
On Thu, Jan 27, 2011 at 9:04 PM, shannu shannu shannur...@yahoo.comwrote:    Hi Ashish, Life and death matter, I have a workbook and again it has diff sheets like sheet 1 to sheet 11. and now my task is to copy unique names from sheet 1 search in other sheets if it is existing then I need

RE: $$Excel-Macros$$ How to consolidate the data using macro

2011-02-11 Thread shannu shannu
one of the beautifull macro, but alas if i could specify sheet names from 2 diff workbooks to merged it would help me.   Regards, Shahina --- On Sun, 10/31/10, Randhir Singh sehrawat...@gmail.com wrote: From: Randhir Singh sehrawat...@gmail.com Subject: RE: $$Excel-Macros$$ How to consolidate

Re: $$Excel-Macros$$ build a database from multiple workbooks

2011-01-27 Thread shannu shannu
Hi Ashish,   Life and death matter, I have a workbook and again it has diff sheets like sheet 1 to sheet 11. and now my task is to copy unique names from sheet 1 search in other sheets if it is existing then I need to copy only those row from the diff sheets and create a fresh new workbook and

Re: $$Excel-Macros$$ Sales Dashboard

2011-01-20 Thread shannu shannu
not good, u r showcasing more data in charts and diagrams an dnot in numbers.   Regards, Shahina --- On Wed, 1/19/11, Kal xcel kalx...@gmail.com wrote: From: Kal xcel kalx...@gmail.com Subject: $$Excel-Macros$$ Sales Dashboard To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI

Re: $$Excel-Macros$$ Urgent Query

2011-01-14 Thread shannu shannu
Hi Noorain,   Its good, but I have a situation here were for A i have 2 industry names mentioned by and both have same values. how can i delete an entry an dkeep one entry.   eg   A   Professional   2000 A   Service   2000 A   total   2000 B   Manufacturing 4000 B  

$$Excel-Macros$$ need some samples of sales analysis!!!! life and death matter :-( !!!!!

2009-07-30 Thread shannu shannu
Hi all,     Need your help urgently, I am new to sales analysis, can someone give me anu sample excel data like gap analysis, wht if analysis etc.     Regards, Shannur --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Segregation of data on a button click in excel

2009-07-28 Thread shannu shannu
().     On Tue, Jul 28, 2009 at 10:44 AM, shannu shannu shannur...@yahoo.com wrote: Hello Dave,     Incase if I have to assemble all the different cell values like i3, j3,toz3 all these cell data to be assembled in one particular cell how to go about it and all this data should

$$Excel-Macros$$ Re: Segregation of data on a button click in excel

2009-07-27 Thread shannu shannu
Hello Dave,     Incase if I have to assemble all the different cell values like i3, j3,toz3 all these cell data to be assembled in one particular cell how to go about it and all this data should appear one after the other and in one whole cell. --- On Tue, 7/28/09, Dave

$$Excel-Macros$$ Re: Hi Urgent Excel help required.!!!!!!!! URGENT!!!!!!!!!!!!!!!!!

2009-06-03 Thread shannu shannu
ws.Application.Run Macro1 End If Next End Sub Sub Macro1() Range(A2:B13).Select ' select all the data range Selection.Copy Sheets(Summary Sheet).Select ActiveSheet.Paste End Sub shannu shannu wrote: Hi All       I have many sheets and I want to copy in one main excel sheet but I want

$$Excel-Macros$$ Hi Urgent Excel help required.

2009-05-22 Thread shannu shannu
Hi All       I have many sheets and I want to copy in one main excel sheet but I want to copy ne after the other exce sheet's data, it shd be like a ladder or a staircase.   Sheets like A1, B1, C1 etc and one man sheet called JAN. I want to copy all the visible rows which are

$$Excel-Macros$$ Re: Urgent help filter macro

2009-04-15 Thread shannu shannu
havent heard, still waiting for the answer, wake up... --- On Tue, 4/14/09, shannu shannu shannur...@yahoo.com wrote: From: shannu shannu shannur...@yahoo.com Subject: Urgent help filter macro To: excel-macros@googlegroups.com Date: Tuesday, April 14, 2009, 10:16 AM Hi All

$$Excel-Macros$$ Urgent help filter macro

2009-04-14 Thread shannu shannu
Hi All,       Can anyone help me in creating a macro. example for filter for employees like  Kishore and wht ever value appears in column B copy and paste it in a fresh excel like in sheet 1 and in sheet 2 of the same workbook paste another employee's data in sheet 2 etc like this.