Re: $$Excel-Macros$$ need macro to generate serial no

2015-08-28 Thread Abhishek Jain
Your query is not clear...please elaborate. On Sat, Aug 29, 2015 at 9:24 AM, My Excel wrote: > any macro solution ? > > > On Thu, Aug 27, 2015 at 10:18 PM, My Excel wrote: > >> Sir, >> >> need help on serial no generate (like attached file) >> >> using auto increment loop >> >> start from 120

Re: $$Excel-Macros$$ sharing a template for accounting

2015-08-28 Thread GENIUS
Thank you very much for sharing the workbook, but it requires more comprehensiveness, I dont know about your accountancy knowledge but if you understand then i want to share some more points to be included in this workbook then we may say that it now a complete and comprehensive workbook. now

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-08-28 Thread SUDHIR VERMA
Dear Friends, i am sudhir. i had connected with this group for very long time. I have learn much more past 7 years from this group. Currently i am working as sales Mis coordinator. Thanking You Regards Sudhir On 27 August 2015 at 19:11, karthik v wrote: > Hello All, > > I am Karthik. I have bee

Re: $$Excel-Macros$$ need macro to generate serial no

2015-08-28 Thread My Excel
any macro solution ? On Thu, Aug 27, 2015 at 10:18 PM, My Excel wrote: > Sir, > > need help on serial no generate (like attached file) > > using auto increment loop > > start from 1200 to > > better if possible 1 crore in 1 sheet > thanks, > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:

Re: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

2015-08-28 Thread SUDHIR VERMA
thanks to both of your for prompt support. On 29 August 2015 at 01:03, Haroon Rasheed wrote: > *There are many methods and ways to convert text into numbers try below on > the whole column will help you in a sec.* > > > > Use the Paste Special Command > > To use the *Paste Special* command, foll

$$Excel-Macros$$ Macro for iMac excel Pivot table save as PDF

2015-08-28 Thread Mike B
Hi All, i would appreciate any help some one could give me. I have an Excel Pivot Table in the Excel 2016 for the iMac , it contains about 100 clients' information and when you choose cell "F2" (which is a drop down) it changes the to the client name and all of information pertaining to that c

RE: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

2015-08-28 Thread Haroon Rasheed
There are many methods and ways to convert text into numbers try below on the whole column will help you in a sec. Use the Paste Special Command To use the Paste Special command, follow these steps: 1. In any blank cell, type the value 1. 2. Make sure the cell you typed 1 in is form

$$Excel-Macros$$ Client Inc in Houston TX need Mobile Developer with Android and IOS

2015-08-28 Thread MADHU-GenuineItLlc
*Hi Partner,* *Please send resume to **ma...@genuineitllc.com* *Title :Mobile Developer with Android and IOS* *Location: Houston TX* *Duration: 3-6 months* *Details:* Need Mobile Developer Android and IOS experience Must have *Phone Gap,* HTML 5 and Java Script --- *With Warm Regards

Re: $$Excel-Macros$$ Formula needed

2015-08-28 Thread Shrinivas Shevde
Dear Abhishek Really great problem solved. thanks a lot Regards Shrinivas On Fri, Aug 28, 2015 at 12:45 PM, Abhishek Jain wrote: > Hope this helps. > > Whenever you want to make any change in the formula, do it in the first > resulting value, i.e, G2 and remember to press Ctrl+Shift+Enter (not

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

2015-08-28 Thread Paul Schreiner
Are you saying that you'd like a macro that:1) Prompts you to select a folder.2) Opens all Excel files in the selected folder.  ?? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times

Re: $$Excel-Macros$$ sharing a template for accounting

2015-08-28 Thread Ashish Bhalara
​See this attachment. Regards Ashish Bhalara​ On Fri, Aug 28, 2015 at 1:37 PM, GENIUS wrote: > it requires a password to password to open the file > > On Thursday, 27 August 2015 17:36:06 UTC+5, Ashish_Bhalara wrote: >> >> Hi, >> >> See attached file as per your requirement. Enable Macro in Exc

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

2015-08-28 Thread Chandra Shekar
Hello, I need to select folder and wat ever excel files are there in that folder I need to work on it. Is there any way to do this? Even I cannot able to send mail to excel-macros group accidentaly i got unsubscribed may I know wat is the procedure to subscribe again Regards, Chandru On Fri, Aug

Re: $$Excel-Macros$$ sharing a template for accounting

2015-08-28 Thread GENIUS
it requires a password to password to open the file On Thursday, 27 August 2015 17:36:06 UTC+5, Ashish_Bhalara wrote: > > Hi, > > See attached file as per your requirement. Enable Macro in Excel before > use it. > > Regards > Ashish Bhalara > > On Thu, Aug 27, 2015 at 12:20 PM, Izhar > > wrote:

Re: $$Excel-Macros$$ Formula needed

2015-08-28 Thread Abhishek Jain
Hope this helps. Whenever you want to make any change in the formula, do it in the first resulting value, i.e, G2 and remember to press Ctrl+Shift+Enter (not just enter) before dragging it down. Regards, On Fri, Aug 28, 2015 at 12:06 PM, Shrinivas Shevde wrote: > Dear All > Please find query.