Re: $$Excel-Macros$$ Need macro for Vlookup

2016-02-09 Thread Prabhu Pinky
Hi pankaj, Thanks a ton for the coding... It's working very fine as I expected.. Thanks again. Regards, Prabhu.R On Feb 10, 2016 12:03 AM, "Secret Shot" wrote: > Hay Prabhu, > > You can use this code to do your required task. . follow the steps > > Go to visual basic

Re: $$Excel-Macros$$ Need Excel Macro Training

2016-02-09 Thread Prabhakar Thakur
Hi, Please share details in Delhi Thanks, Prabhakar Thakur New Delhi +919953736776 On Mon, Feb 8, 2016 at 12:33 PM, Prabhakar Thakur < prabhakarthak...@gmail.com> wrote: > Hi Group Member > > I need excel macro training please share best training institute details > or share link > > > Thanks,

$$Excel-Macros$$ Export to XML with multiple Child elements

2016-02-09 Thread Jonathan Vaz
Hi, I am trying to export data from my excel file to an XML file. I have attached the excel file being used to convert data to XML. Can someone suggest me how to achieve the below. Thanks

$$Excel-Macros$$ URGENT NEED Data Analyst/UAT Tester---Charlotte, NC.

2016-02-09 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title:** Data Analyst/UAT Tester* *Duration: **10+ months* *Location: **Charlotte, NC* *Responsibilities* - Partner closely with the implementation and business teams to support Line of Business

Re: $$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

2016-02-09 Thread Kat
Thank you very much for your help. It's much appreciated. On Friday, 5 February 2016 23:16:28 UTC+8, era_kar wrote: > > Hi, > I give u the following code you can run and get what u expect. For the > next time u have to change the j value(i.e.,column > value,A=1 B=2 etc) to 6 to 7, and next time

$$Excel-Macros$$ Having difficulty sorting based on a column of values

2016-02-09 Thread robflott2
I am working with Excel 2013 and am experiencing difficulty trying to sort a block of data based on a '% share' calculation. Each cell in the '% share' column is a formula; for example B9/$B$29 Where cells B9 through B28 are themselves a formula: (for example cell B9 is

$$Excel-Macros$$ Re: Interest calculation as per we put years in -- D3 -- Can anybody help me out

2016-02-09 Thread big smile
Respected All , Can anybody Help me out for this query. On 9 February 2016 at 12:36, big smile wrote: > Respected All, > > Can i have solution for this my query .. > > > > On 8 February 2016 at 17:57, big smile wrote: > >> Respected All Excel

$$Excel-Macros$$ To insert new row below when the data is unmatched

2016-02-09 Thread Kat
Hi all, I'm trying to insert a new row below the matched data in trial.xlsm and copy the unmatched data and write 'New' in column B when the data is found unmatched. However, I can't achieve this. I've attached the pp.xlsx file in which the Sheet2 in pp.xlsx is the result that I want to

Re: $$Excel-Macros$$ Need macro for Vlookup

2016-02-09 Thread Prabhu Pinky
Hi Pankaj, I just noticed, that in output "Start" and "End" time seems same. Regards, Prabhu.R Thanks & Regards, Prabhu R On 10 February 2016 at 01:26, Prabhu Pinky wrote: > Hi pankaj, > > Thanks a ton for the coding... > > It's working very fine as I expected..

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

2016-02-09 Thread sanglesneha17
On Thursday, 10 May 2012 16:49:25 UTC+5:30, NOORAIN ANSARI wrote: > > Dear Group, > > Please find attached Interview questions and answers for MS Excel+VBA+MS > Access+SQL Server. > > If any one have this type of question and answers, Kindly share with group. > > > > > -- > Thanks & regards, >

$$Excel-Macros$$ Re: Day, Date, Months

2016-02-09 Thread Mandeep Baluja
We can't entertain manual changes request, As your data is not correct Lots of typo errors in this Ex: "Wednesdsy",Extra Spaces in no particular trend Regards, Mandeep baluja -- 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