Re: $$Excel-Macros$$ Query 3

Hi Kalyan, PFA the file updated with formula . I use index and Match Function to get the results. thanks, Sarva Thanks & Regards, *Saravanan Raju* Mob: +91 8807708842 +91 9449716334 On Tue, Nov 15, 2016 at 4:24 PM, Kal xcel wrote: > Dear Experts, > > Please help

$$Excel-Macros$$ Macro to extend the table to have next year

Hi Friends, I need your help to build macro to extend the table with next year data in the same table(Range). Please attached the file , column B:D is the input table, and column F:H is the output table. 1> I need to copy the vendor A data(B5:D7) from 2016 (Latest) and insert this below the

Re: $$Excel-Macros$$ Urgent need for Sharepoint Architech --Pittsburg ,PAb

Bvhcgh you are yycyucbd -- 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, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Urgent need for Sharepoint Architech --Pittsburg ,PAb

Bvhcgh you are yycyucbdb -- 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, accurate thread titles. Poor thread titles, like Please

$$Excel-Macros$$ Excel Books

Hello Experts, Please provide me the sites for excel VBA 2013 books. Thanks & Regards, *Saravanan Raju* Mob: +91 8807708842 +91 9449716334 -- 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 @

Re: $$Excel-Macros$$ HArddisc Space Utility charts

On 28-Sep-2015 11:50 am, "saravanan R" <sarva0...@gmail.com> wrote: > Hi Experts, > > I need your help on plotting an chart for HArd disc space utility. > Please find the scenario below, > I have 2 servers, each server as 3 drives and details of Space util

$$Excel-Macros$$ HArddisc Space Utility charts

Hi Experts, I need your help on plotting an chart for HArd disc space utility. Please find the scenario below, I have 2 servers, each server as 3 drives and details of Space utilization of ech drive is given in the Attached excel file. Can you please advise me how to plot the chart for the given

Re: $$Excel-Macros$$ Excel to Pdf

Hi Paul, I found macros to export all the sheets to PDF, but I need to select only the specified sheets into PDF. If you have any references please share. It will be very useful for me to make this task bit easier. Thanks, Saravanan R On 13-Aug-2015 7:44 pm, Paul Schreiner schreiner_p...@att.net

$$Excel-Macros$$ Excel to Pdf

Hi, I have an query about exporting each sheet(multiple sheets but not all) of the excel workbook to Pdf and save this PDF by name provided in the list. This task should be automated, because there are 20 to 45 sheets in the report. Please help me sort out this time consuming task. thanks in

Fwd: $$Excel-Macros$$ PIVOT TABLE CHART TAKE SCREEN SHOT

Hello Team, I have an requirement where the data from Pivot table chart as to be copied into the Power point slide(or in the excel itself as bitmap image) . In the same pivot table i have multiple filter(values) to select. since I have to take 12(conditions) print screen from same pivot table

$$Excel-Macros$$ PIVOT TABLE CHART TAKE SCREEN SHOT

Hello Team, I have an requirement where the data from Pivot table chart as to be copied into the Power point slide(or in the excel itself as bitmap image) . In the same pivot table i have multiple filter(values) to select. since I have to take 12(conditions) print screen from same pivot table

Re: $$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

On Wed, Mar 18, 2015 at 5:31 PM, saravanan R sarva0...@gmail.com wrote: Hi Mandeep, Thanks a Million. I have one more query related to the same file, is it possible to split the file based on Status OK wrt to each Coleague. and file name should be QueryDup-FK QueryDup-BD (colleague name

$$Excel-Macros$$ Query Regarding Duplicate and Update Status

only. If the DOC no. is Duplicating then Update Status as OK, if it is Unique then update as NOT OK thanks in advance, Saravanan R +91 8807708842 +91 9449716334 -- 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

Re: $$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

baluja mandeepbal...@gmail.com wrote: Try this .. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wrote: Hello Team, I have an Query

Re: $$Excel-Macros$$ Re: Import file from Text Fil

Hi Mandeep, Thanks For your quick response, This is what actually i needed. Thanks a Lot Regrads, Saravanan On Mon, Dec 29, 2014 at 11:35 AM, Mandeep Baluja rockerna...@gmail.com wrote: Sub Macro1() Dim fName As String fName = Application.GetOpenFilename(Text Files (*.txt), *.txt) If

$$Excel-Macros$$ Date format

Hi Team, I have an query on replace . with / in the Data pulled from SAP . Actually Format is, 01.12.2014 17.12.2014 WHen I Do Manually Find Replace, It show me as , 1/Dec/14 17/Dec/14. But when I do through VBA COde, I replace as, 12/Jan/14 INVALID DATE FORMAT) Can You please check in and

$$Excel-Macros$$ VBA to Vlookup from other Source!

Hi Team, Please help me on Vlookup function where I will need to refer the file(by browsing the path) and update the correponding data in the current file. requirement as below: col x=vlookup(col A current working file, rng, 2,0) Col x A refers to the current working file but range I have to

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

i am looking for VBA Macro for this , reference file to opened by browse option then select the range. thanks regards, Saravanan On Mon, Dec 29, 2014 at 6:45 PM, saravanan R sarva0...@gmail.com wrote: Hi Team, Please help me on Vlookup function where I will need to refer the file

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

Reason behind is, I am Working on a multiple manual task in one report, like already enquired, pulling data from Text file, changing data formats, based on this data pull information from other source, clean up templates. etc regards, saravanan R On Tue, Dec 30, 2014 at 12:33 PM, Mandeep Baluja

Re: $$Excel-Macros$$ Re: Import file from Text Fil

Hi Mandeep, This what I needed, but through VBA code. Because i Have to get this imported Data into other excel Template. Can you please share how we can proceed through VBA. thanks regards, Saravanan R On Fri, Dec 26, 2014 at 5:28 PM, Mandeep Baluja rockerna...@gmail.com wrote: Want

$$Excel-Macros$$ Import file from Text Fil

Hi Team, I have an query on Importing text file , delimit by Seperator and make particular column to be text, and import the same data into excel update those data from Row 2. thanks regards, saravanan R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2

Re: $$Excel-Macros$$ Re: Import file from Text Fil

here it is On Fri, Dec 26, 2014 at 4:55 PM, Mandeep Baluja rockerna...@gmail.com wrote: send file On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote: Hi Team, I have an query on Importing text file , delimit by Seperator and make particular column to be text, and import

Re: $$Excel-Macros$$ Fwd: Excel Spellcheck Help.

Hi Frnds, Any Idea for the given below Reuqest? *Thanks Regards,* *Saravanan R* *BDI India Private Limited* “Shreeshyla”, Doddakallasandra, Kanakapura Road, Bangalore 560 062 INDIA Ph: 91-80-22560418/19 Fax: 91-80-22560420 Cell: +919449716334 sarava...@bdi-india.com

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

Hi Xlts, Thanks for all your Inputs and suggestions. Finally I could able to Sort it Out by Countif and Vlookup Function. Please refer the file attached. thanks, Saravanan On Thu, Oct 25, 2012 at 10:11 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Pl Share a sample sheet with us On

$$Excel-Macros$$ Sorting option in Filter Disable-Shortcut Key.Excel 2007

Hi Excelates, I need an Urgent help on disabling the Sort in the filter dropdown. Is there a way to disable only the short cut key i.e only the letter s a in the Filter Drop down list.(available in the Excell 2007) thanks regards, Saravanan --