Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-27 Thread thameem
Still getting hanged, even it was converted in to binary file, i tried to delete empty rows, but not working On Thu, Jun 27, 2013 at 9:55 AM, Amit Desai (MERU) amit.de...@merucabs.comwrote: It might be due to low RAM. If you are using MS Excel 2007, change the file type to “Excel Binary

Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-27 Thread VBA VABZ
Hi Either your table is corrupted, re-created new excel file using pasting values. Best Luck. On Thu, Jun 27, 2013 at 11:45 AM, thameem thamee...@gmail.com wrote: Still getting hanged, even it was converted in to binary file, i tried to delete empty rows, but not working On Thu, Jun 27,

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

2013-06-27 Thread xlstime
Welcome Sandeep Looking forward to your active participation in group. Keep posting . Enjoy Team XLS On Thu, Jun 27, 2013 at 10:57 AM, sandeep shivpujan singh mandy07s...@gmail.com wrote: Hi Everyone, I am Sandeep S Singh from India Hyderabad. I am a Software

Re: $$Excel-Macros$$ Pie Chart Help

2013-06-27 Thread priti verma
Hi vijay, Pfa for more clarification On Wed, Jun 26, 2013 at 1:57 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected priti, I tried to paste the donought chart on the pie chart,but only a single chart is showing not both charts,how should we make both charts show at a time like the

Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-27 Thread Bruno7Borges
Try Able2extract. For me it is the best software, of its kind. The only disadvantage is that its a paid software.. Quarta-feira, 26 de Junho de 2013 5:45:20 UTC+1, Francis Mukobi escreveu: Basole ricar...@gmail.com javascript: wrote: Hamood, post your PDF file and tell what data you want to

$$Excel-Macros$$ Copy data from one sheet to another by matching column header

2013-06-27 Thread rohan . ghatak . 85
Hi Friends, I Have an workbook, where i want to copy data from one sheet to another sheet by matching column header and also to format the destination column in general format is there any VB Code for it i have this code with me but it gives me error 400, please help Sub Test() Dim rng As

$$Excel-Macros$$ how to solve international decimal and comma separator issue,

2013-06-27 Thread Divaker Pandey
Hi Expert, how to solve international decimal and comma separator issue, it data download from web in US Format Thanks Regards, Divaker -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Need help

2013-06-27 Thread thameem
Dear all, one more help needed, I want to highlight range of cells, based on today date, for example, i have file 1 and file 2, I will update file 1 every time and there is link (vlookup) in file 2 with file 1, in file 1, I will just enter dates, suppose i opened file 2, if there is dates of

Re: $$Excel-Macros$$ Need help

2013-06-27 Thread thameem
there is prob, i tried one formula {=A10=today()}, but its not getting highlight, might be because of vlookup, example i added vlookup formula, for A10, based on A10 cell date, I need to highlight A1:A10 On Thu, Jun 27, 2013 at 4:04 PM, Divaker Pandey divake...@gmail.com wrote: See in

$$Excel-Macros$$ RE: Job | Urgent Requirement MIS Executive (Experience : 2-3 Yrs)

2013-06-27 Thread Excel Learn
Dear group members, Please find the job description Walk-In Interviews Please contact me on +91 – 9871852097 or 011 - 45244577 to confirm your attendance at the interview. Experience: 2-3 year Location: New Delhi Salary : 1,40,000 – 2,10,000 Education: Any Graduate

Re: $$Excel-Macros$$ how to solve international decimal and comma separator issue,

2013-06-27 Thread P.VIJAYKUMAR
Respected Divakar, You can check the following link.It might be of some help to you. http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html Regards, VIJAYKUMAR On Thu, Jun 27, 2013 at 4:16 PM, Divaker Pandey divake...@gmail.com wrote: Hi Expert, how to solve

$$Excel-Macros$$ Macro Require

2013-06-27 Thread vikas khen
Dear All, Please find the excel sheet. I need macro for the same Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

Re: $$Excel-Macros$$ Macro Require

2013-06-27 Thread xlstime
why need macro ?try pivot table please find attached file . Enjoy Team XLS On Thu, Jun 27, 2013 at 6:30 PM, vikas khen vikk...@gmail.com wrote: Dear All, Please find the excel sheet. I need macro for the same Regards -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Problem with addresslocal property in setting chart series

2013-06-27 Thread Martien Janssen
Dear all I have the following code to set the name and x and y properties of a chart series. These need to refer to a certain worksheet (T1, T2, etc identified by the parameter Tsel) and to a certain range on these sheet. .SeriesCollection(nl).Name = ='T TSel '!

Re: $$Excel-Macros$$ Duplex Print Setting for Each Sheet via Macro (Excel 2010)

2013-06-27 Thread Chris
Unfortunately, it doesn't work. I do print all sheets at once, by selecting all sheets and then click print (with duplex). However, before I do that, I have to select every sheet individually and select print duplex. Then, I can select them all and actually print them in duplex. Christoph On

$$Excel-Macros$$ To count values in a changeble range

2013-06-27 Thread Thiago Souza
I need some help with a code to the workbook uploaded. I'm having a hard time in finding a way to start! The workbook is to control day works of employes where they cannot work more than 183 days in the last 365 continuous days. I need a code where based on the selected cell it shows me

$$Excel-Macros$$ Autofilter criteria

2013-06-27 Thread rekha siri
Hi Experts, Please help in this concern i am attaching sample data spread from Column A TO H in H Column i want to update Status as per below criteria 1) Filter Reference column -- custom filter -- Begins with ROD OR Begins with ROY Update the Status as Excluded for visible cells in