Re: $$Excel-Macros$$ Autofilter criteria

Dear Rekha, Pl see the attached workbook. Warm Regards, Gawli Anil On Fri, Jun 28, 2013 at 10:36 AM, rekha siri wrote: > 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) F

$$Excel-Macros$$ Autofilter criteria

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

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

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 anywher

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

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 We

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

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 & "'!" & Ce

Re: $$Excel-Macros$$ Macro Require

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

Re: $$Excel-Macros$$ Intersection of points in graph

its a simple x y scatter chart to know more about charts visit http://office.microsoft.com/en-in/excel-help/creating-xy-scatter-and-line-charts-HA001054840.aspx Regards Ashish On Thu, Jun 27, 2013 at 6:20 AM, Krishnaraddi V. Madolli < krishnaraddi.mado...@asia.xchanging.com> wrote: > Thanks

$$Excel-Macros$$ Macro Require

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, accura

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

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 wrote: > > Hi Expert, > > how to solve international

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

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 & Dipl

Re: $$Excel-Macros$$ Need help

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 wrote: > See in attached screen shot > >

$$Excel-Macros$$ Need help

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 to

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

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 @ https://ww

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

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 Ran

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

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 > wrote: > > >Hamood, post your PDF file and tell what data you want to import > > > > > > > >Em