$$Excel-Macros$$ combine 2 excel workbook using macros selecting only selected rows

2016-01-13 Thread devi priya
Hi I need help in using macros to combine the two excel sheet and generate an output as attached,, this is an automated process which should happen every week, please help me in macro codes.. sample 1 and sample 2 are the input sheets and the output sheet is the 3rd one.. pls have a look and

$$Excel-Macros$$ update modified details in excel automatically

2016-01-13 Thread Kat
Hi all, I've created a vba code for extracting files from folder with its details. I would like to know how could I make the excel update the content automatically by itself if there is any changes in the folder such as a file is deleted, new file is updated, file is being modified etc. Than

$$Excel-Macros$$ Client in Bowie, MD need Clarity PPM Consultant

2016-01-13 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title: CA Clarity PPM Consultant Location: Bowie MD Duration: Long Term* *Job Description:* We are seeking an IT professional with extensive Clarity PPM experience to help our client design and implement

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

2016-01-13 Thread GENIUS
Thank you for your help On Monday, 11 January 2016 10:11:15 UTC+5, Abhi wrote: > > When you are subtracting, you are excluding the start date. > > > > On Mon, Jan 11, 2016 at 10:30 AM, Izhar > > wrote: > >> Please open the attachment see the question. >> Thanks in advance. >> >> -- >> Are you =

$$Excel-Macros$$ Urgent need Oracle DBA--Fort Worth, TX ---locals Only -F2F

2016-01-13 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : Oracle DBA * *Duration :6 months * *location :**Fort Worth, TX* - Need locals as there is an *in-person interview * *Job Description:* - The right candidate will have the role of a Database A

$$Excel-Macros$$ How to make a Conditional macro in Excel based on two or more conditions

2016-01-13 Thread Jyotirmaya Chandra
I have 3 sheets Sheet1 name - Demand Sheet2 name - Collection Sheet3 Name - Balance Demand means A user is having some Due for a particular product Collection means the amount collected from that person for that product Balance means the person is due the rest amount i.e Balance = Demand -

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-01-13 Thread Pankaj Sharma
check this out !!! *PJ * *MIS Analyst* *Greater Kailash-1, New Delhi.* *Instagram* *pj_sharma_* *Tweeter* *dude_sharma_pj**Facebook** www.facebook.com/dude.pj * *We meet for a reason, eith

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

2016-01-13 Thread Devendra Sahay
Hi, Sample of the data is attached. Please check ​. Thanks, -- 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

$$Excel-Macros$$ Sorting Comma Separated Values in a cell

2016-01-13 Thread Devendra Sahay
Hi Experts, Currently I am using below code to sort comma separated values within a cell but In case I have to sort these value with their respective ref. name. this code sorts the values & the ref. name alphabetically & data shuffled all the data, So because of this am unable to reconcile the dat

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-01-13 Thread mohd sadiq
Team , Please help to closed it on priority On Fri, Jan 8, 2016 at 2:03 PM, mohd sadiq wrote: > Opsss , sorry > > PFA the same. > > On Thu, Jan 7, 2016 at 7:16 PM, Pankaj Sharma > wrote: > >> where is the attachment. ??? >> >> >> >> *Pankaj Sharma