$$Excel-Macros$$ Urgent need SAP EHS Techno-Functional Consultant---Rancho Cordova, CA

2016-02-10 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title :SAP EHS Techno-Functional Consultant* *Location: Rancho Cordova, CA* *Duration: 15 months+* *Mandatory Qualifications* Bachelor’s degree (or equivalent); or a certificate from an

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

2016-02-10 Thread Devin
Hi Ayush and All, I am Devin and currently in the Supply Chain industry. I am a business user and build many reports for analytics and decision making purposes. Macros had helped me in cutting down the reports from days to seconds or minutes (depending on the size of my data). I am keen to

$$Excel-Macros$$ Urgent need Senior Microsoft Dynamics CRM Architect--Fort Worth, TX

2016-02-10 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : Senior Microsoft Dynamics CRM Architect * *Duration : 6-11 months * *Location :**Fort Worth, TX* JD:- A nationwide industry leader is seeking a Senior Microsoft Dynamics CRM Architect for a 11

$$Excel-Macros$$ How can I add 2-6 characters to the front of numbers based ONLY on how long the number is?

2016-02-10 Thread Paul Bevins
Hi, I've got an odd problem. I have a database of some 15000 numbers. 10,000 of them (roughly), go from 1 to 10,000. Another 5,000 go from 1,000,000 to 2,000,000. However, the numbers SHOULD AB1 to AB1. I need to be able to type the root number in and have Excel decide what it needs:

$$Excel-Macros$$ No Body reply --- Interest calculation as per we put years in -- D3 -- Can anybody help me out

2016-02-10 Thread big smile
Dear All Friends No body reply On 10 February 2016 at 09:48, big smile wrote: > 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

$$Excel-Macros$$ Re: How can I add 2-6 characters to the front of numbers based ONLY on how long the number is?

2016-02-10 Thread Paul Bevins
Okay, after a bit of research, I've gotten a sort of formula: =IF((A1)>10,(A1),(CONCATENATE("AB",(TEXT(A1,"0") This actually does what I wanted. However, I'd still like to have the final number be just a literal number, not a formula. Assuming A1 is the original number and B1 is

$$Excel-Macros$$ Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-10 Thread zaks
Is there any way to copy data from different sheets and place it in 1 summary sheet (200+ worksheets in 1 excel file) will be great help if anyone has an answer 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

$$Excel-Macros$$ Re: How can I add 2-6 characters to the front of numbers based ONLY on how long the number is?

2016-02-10 Thread Paul Bevins
Okay, after a bit of research, I've gotten a sort of formula: =IF((A1)>10,(A1),(CONCATENATE("AB",(TEXT(A1,"0") This actually does what I wanted. However, I'd still like to have the final number be just a literal number, not a formula. Assuming A1 is the original number and B1 is

$$Excel-Macros$$ Re: Multiple Mail merge same page

2016-02-10 Thread Mandeep Baluja
> > Use a mail merge option in word You can refer to google to see step by > step process,In my early phase I tried this for more than 2000 > customers,Create an excel sheet set the tags in Word mail merge it will > create that for you. Regards, Mandeep baluja -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Multiple Mail merge same page

2016-02-10 Thread Murali Nagarajan
Dear All, Please help me that how to make multiple mail merge same page . I have more than 200 customers details ( Ma,e,Address,contact no,) -- 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$$ Re: Introduce Yourself !!

2016-02-10 Thread Paul Bevins
Hi, I'm Paul. Just a normal guy, I like to think of myself as tech savvy & have had a business at various times supporting both PCs and Microsoft in general. That said, Not always so good with Excel. Hoping to get some tips. Paul On Friday, June 8, 2012 at 12:21:59 PM UTC-7, Ayush Jain wrote:

$$Excel-Macros$$ Re: How can I add 2-6 characters to the front of numbers based ONLY on how long the number is?

2016-02-10 Thread Paul Bevins
Guess, I could add that I've used: Concatenate ("",A1) to give me all my zeros. Right (A2,5) function, to reduce the number to just the five digits, or six to give me six digits. Then I've used Concatenate ("AB",A1) which will give me all of these numbers, EXCEPT the six digit ones. I can't