RE: $$Excel-Macros$$ Excel Data Automator

Hi Paul, I've installed it on my own laptop at home. I am the only user, and don't have to log in. How do I know if I'm "admin"? Dave. Date: Sat, 23 Jan 2010 12:32:04 -0500 Subject: Re: $$Excel-Macros$$ Excel Data Automator From: pau...@gmail.com To: excel-macros@googlegroups.com Are you logge

Re: $$Excel-Macros$$ Delete rows only if the entire row is empty

Dear Vinod, You are welcome...!! Solving query and Posting query, both are meant for learning enhancement. So no worries.. :) Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/24/10, Vinod N w

Re: $$Excel-Macros$$ Delete rows only if the entire row is empty

Thanks Dave and Dilip Solution is as per my requirement Anil: I'm at present deleting blank rows using filters... and was check with the group for a better alternative Thanks a lot for your concern Indeed its a pleasure to be a part of this group.. Eventhough I did not reply/solve

Re: $$Excel-Macros$$ Exporting data using Pulldown List

Hi Ankur, This is what I wanted.Thanks for your help! Is it possible that I can convert your formula (B5:N23) in array formula? Regards, Sandip On Thu, Jan 21, 2010 at 11:55 PM, ankur wrote: > HI SANDIP > if you need any other clarification , plz let me know > Have A Nice Time & Enjoy Life >

Re: $$Excel-Macros$$ Excel Data Automator

Are you logged in using "admin" account? It tries to read the registry for the list of ODBC links set up in your machine, so you account has to be able to read registry. On Sat, Jan 23, 2010 at 12:37 AM, Dave Bonallack wrote: > Hi Paul, > I've installed the add-in, but when I select Control Pan

RE: $$Excel-Macros$$ Function to return days by month

Dilip, thanks a lot, but my problem is EOMONTH function. Isn't part of the Analisys Toolpack?? I can't use it, since this file will be distributed to more than 2000 people, and they might or might not have the addin installed. Is it possible to add the EOMONTH function as UDF, thus it can be av

Re: $$Excel-Macros$$ Function to return days by month

Thanks Celcilia, There are other workarounds available, which we can use instead of EOMONTH. and now I got your main requirement as well. If you wish, you can include a code which will autmatically enable / installs the ATP, when the users open the workbook. For the later part, I was also lookin

Re: $$Excel-Macros$$ Macro Pivotable

Dear Rajesh, I hope I am not late in replying to this email:- Options which you can exercise:- 1) Try including Track Changes Feature 2) Include Password to Open 3) Include Password to Modify, as per your choice. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 98109

Re: $$Excel-Macros$$ Macro Pivotable

Dear Worawat, As you are not clear in your query, you should go for learning Pivot Table codes to help yourself. :) There are many tutorials available on web, and one of them is given below. http://www.ozgrid.com/News/pivot-tables.htm Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),

Re: $$Excel-Macros$$ Concatenation based on criteria in other columns?

Hi Myke, Try below formula:- =IF(C1="Inadequate",A1&" "&B1&" "&C1&CHAR(10),"") Workbook containing the same formula is also attached. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/20/10,

Re: $$Excel-Macros$$ add-in manager

Dear Frederic, Try below link:- http://support.microsoft.com/kb/282847 Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/21/10, Frédéric wrote: > > Hello, > > I use Excel 2003 and I would li

Re: $$Excel-Macros$$ delete row only the next mob no same

Dear Manoj, This can easily be taken care off and earlier I have provided solutions to these types of queries. It would be great if you can provide a sample data. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New

Re: $$Excel-Macros$$ Function to return days by month

Dear Cecilia, Solved workbook is attached herewith. I foresee that the solution can futher be customised, if you find this interesting and useful. Let me know in case of any queries. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dil

Re: $$Excel-Macros$$ Delete rows only if the entire row is empty

Dear Vinod, Below is what I have written today for some other group member, you can use this. First set is for Row and second set is for Column. If you search within my replies for today, you can find the attached workbook also. Sub delR&C() Cells(1, 1).Select For n = 1 To Range("a65536").End(xl

Re: $$Excel-Macros$$ VBA code to delete all unused rows and columns

Dear Mike, Following code will delete the blank rows and columns as per your requirements:- Sub delRows() Cells(1, 1).Select For n = 1 To Range("a65536").End(xlUp).Row Selection.EntireRow.Select If Application.WorksheetFunction.CountA(Selection) = 0 Then Selection.EntireRow.Delete Else ActiveCell

Re: $$Excel-Macros$$ Single Cell Text Manipulation

Dear Steve, An formulation is done and tested in attached file. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/23/10, nemadrias wrote: > > Hi all - I'm looking for some help with a macro,

Re: $$Excel-Macros$$ Link from one excel file to another excel file

Dear Mani, Your message / query is not clear. It would be great if you can attach the spreadsheet along with the target results which you are seeking for. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi -

$$Excel-Macros$$ Link from one excel file to another excel file

I have one excel file it is conten spreadsheet first have some coloum Raman Stock details DateBillno Type of invoice type of goods nameofrep top1top2 top 3 top4 01.01.2010 Opening ALL raman 100 100 100 100 21.01.2010 4325Saletop1

Re: $$Excel-Macros$$ Automatic goal seek...

hi sagaraher y dont you record a macro for that Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Jan 23, 2010 at 12:41 PM, sagaraher wrote: > Hi frds. > > plz anyone tell me, is ther ny way to us goal seek automa

Re: $$Excel-Macros$$ Automatic goal seek...

Dear Sagaraher, You can get this working, if you use Goal Seek Code in Worksheet Change event. Same is done in the attached workbook. Let me know in case of any queries. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.