Re: $$Excel-Macros$$ Re: pdf converter software code needed (able2extract)

2010-02-26 Thread anil panchal
Share With Exe File Please Regards Anil Kumar On Fri, Feb 26, 2010 at 12:02 PM, ankur ankurpande...@gmail.com wrote: ya sure this is the code 127418901528 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

$$Excel-Macros$$ How to select unique values from a list and copy each unique value to another location of another worksheet

2010-02-26 Thread OSAVentures Calamba
How to select unique values from a list and copy each to another location of another worksheet? Not using auto-filter or advance filter? Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Inventory

2010-02-26 Thread Abhishek Jain
Thanks Man...That works. Regards...Abhishek On Fri, Feb 26, 2010 at 12:33 PM, ankur ankurpande...@gmail.com wrote: hi abhishek luckily i got 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 Fri, Feb 26, 2010

$$Excel-Macros$$ Need either excel formula or Macro

2010-02-26 Thread Puttu
Hi Team I need help either in excel formula or macro for the product code need to splits in different sheets. 1. Data Sheet contains All product codes 2. Goods No.1 2 contain selected goods code item. 3. Other Goods sheet blank I need what ever the product available in Data Sheet it should

Re: $$Excel-Macros$$ Re: pdf converter software code needed (able2extract)

2010-02-26 Thread ankur
hi anil this is not a excel file its a software to convert files able2extract professional version u can download that on from internet 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 Fri, Feb 26, 2010 at 12:04 PM,

Re: $$Excel-Macros$$ Need help for macro- changing cell value

2010-02-26 Thread Christopher Luka
See attached. On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab mahes...@gmail.com wrote: Dear All I need macro for when i open workbook, A1 cell value, will display 1 to 4 numbers one by one, time interval should be 15sec. i want this to create animation effects in pie chart, cell A1 is link

Re: $$Excel-Macros$$ pls help - Vertical to Horizontal

2010-02-26 Thread Christopher Luka
You might also look up 'loan amortization' in online templates in Microsoft Office. The formulas are all built in so you can study them. On Thu, Feb 25, 2010 at 9:59 PM, ankur ankurpande...@gmail.com wrote: hi umesh for learning vba , u can download books from our file section Have A Nice

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-02-26 Thread Christopher Luka
See attached for example. On Thu, Feb 25, 2010 at 9:44 PM, Ayush jainayus...@gmail.com wrote: Hi Markkim, Would you please send the sample file containing this data? Best regards, Ayush Jain On Feb 26, 6:18 am, Markkim mark@gmail.com wrote: Hi I have been trying to make these but

Re: $$Excel-Macros$$ Converting .xlsm to .xls

2010-02-26 Thread rf1234 rf1234
Click on start download After executing the following link http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=941b3470-3ae9-4aee-8f43-c6bb74cd1466displayLang=en Microsoft by default have a problem to work from higher virson to lower version. such example is installing win 98

Re: $$Excel-Macros$$ How to select unique values from a list and copy each unique value to another location of another worksheet

2010-02-26 Thread ankur
hi OSAVentures Calamba check this link http://blogs.techrepublic.com.com/howdoi/?p=111 VBA, the automated way First, create two ranges: the list’s source data and a target range for the unique list. Select the source data; in this case, that’s cells A2:A18. From the Insert menu, choose Name

Re: $$Excel-Macros$$ Cell Formating

2010-02-26 Thread ankur
format the cells of whole sheet in general format... if still problem check this link http://www.brighthub.com/computing/windows-platform/articles/27366.aspx 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 Fri, Feb

Re: $$Excel-Macros$$ Cell Formating

2010-02-26 Thread Sachin Shukla
Dear Mr. Pandey, It's happen even I open new sheet. I thiks somewhere problem in setting. What's your suggestion?. Thanks Sachin Shukla On Fri, Feb 26, 2010 at 2:53 PM, ankur ankurpande...@gmail.com wrote: format the cells of whole sheet in general format... if still problem check

Re: $$Excel-Macros$$ Cell Formating

2010-02-26 Thread VIRAL PANDYA
hit CTRL + SHIFT + ~KEY... Regards, Viral Pandya On Fri, Feb 26, 2010 at 2:53 PM, ankur ankurpande...@gmail.com wrote: format the cells of whole sheet in general format... if still problem check this link http://www.brighthub.com/computing/windows-platform/articles/27366.aspx Have A

$$Excel-Macros$$ PLEASE HELP

2010-02-26 Thread sudhir kumar
Hi Dear all, Please help me for below formula. 1. how to convert numbers in text. 2. Example 2000Two thousands when i m change the number the text changed automatically. -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 --

Re: $$Excel-Macros$$ PLEASE HELP

2010-02-26 Thread ankur
hi sudhir check this addin and use formula =num2text(a1) a1 is cell having number 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 Fri, Feb 26, 2010 at 4:11 PM, sudhir kumar bluecore...@gmail.com wrote: Hi Dear all,

$$Excel-Macros$$ Please guide me to save time.

2010-02-26 Thread Vinu
Hello Frnds, I am using 2007 excel. My file size is 21 MB. I used *sumifs formulas*extensively in each sheet(total 25 sheets). My problem is whenever I open the file or close or calculate or save it takes much time say 20 min. Would like to make my workbook faster. Could you please guide me.

$$Excel-Macros$$ CENTRAL EXCISE REGISTERS

2010-02-26 Thread HARI NAIR
I am looking for Central Excise Registers, like RG-23A Part-!, II, RG-1 Registers in excel .If anybody have please post Thanks in advance -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ Need procedure to allow VBA code by users during runt-time?

2010-02-26 Thread Dougie Excel
For various reasons a user-defined function of mine needs to allow user input that is interpreted as executable code (in this case any excel expression). The most straight forward approach would be for the function procedure to input code into a module active in the same excel session and

Re: $$Excel-Macros$$ Excel Formulas

2010-02-26 Thread ayush jain
Hi Putta, Attached is updated sheet with formulas. As I have already helped you earlier on same formulas, Please give a try before you send request to group going forward. This group is not formed to get your work done but to get technical assistance only. I hope you understand. Best regards,

Re: $$Excel-Macros$$ Re: Application.commandbars

2010-02-26 Thread Dilip Pandey
Dear Harpreet, Try below link:- http://www.ozgrid.com/VBA/custom-menus.htm -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 2/26/10, Harpreet Gujral harpreetguj...@gmail.com wrote:

RE: $$Excel-Macros$$ Please guide me to save time.

2010-02-26 Thread Dave Bonallack
Hi, Not sure if sumproduct is faster than sumifs. But it may be that much of your data is historical (past months or years) and doesn't update any more. All non-updating cells that contain formulas, could be replaced with just their numerical data. Since your workbook is large, you could write

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-26 Thread ankur
hi hanum plz attach a sample file so it will more easy for us to help u 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, Feb 27, 2010 at 5:01 AM, Hanum harsha...@gmail.com wrote: Both the solutions are not what I