Re: $$Excel-Macros$$ Report

2014-09-29 Thread joseph camill
Hi Paul, Thank you for the effort. The solution provided by Vaibhav has worked per my requirement, Also, your solution on Vlookup is helpful. Thank you Paul. On Mon, Sep 29, 2014 at 5:48 PM, Paul Schreiner wrote: > I threw it together a couple of ways. > Since I don't know how comfortable you

Re: $$Excel-Macros$$ Report

2014-09-29 Thread joseph camill
Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi wrote: > Cheers > On Sep 29, 2014 9:58 PM, "joseph camill" wrote: > >> Hi Vaibhav, >> >> Tha

$$Excel-Macros$$ Fwd: Merge files with few criteria of pasting

2014-09-29 Thread Vinod Narayanan
Hi Gurus, Need your help!. I need to consolidate many files received from various branches from time to time basis. Attached is the sample file wherein I have added 2 worksheets. One is the input file received from Branches and another the Output file. *Input file:* As there files are save

Re: $$Excel-Macros$$ Report

2014-09-29 Thread Vaibhav Joshi
Cheers On Sep 29, 2014 9:58 PM, "joseph camill" wrote: > Hi Vaibhav, > > Thank you for the file and working on suggested changes. It is very > helpful. Will have a look in detail and will revert. > > It is really a great one. > > On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi wrote: > >> 1. Crea

Re: $$Excel-Macros$$ What seems to be a basic formula BUT I cant figure it out! Help,,,,Please

2014-09-29 Thread Ashish Kumar
Welcome!!! -- 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 Help, Urgent

Re: $$Excel-Macros$$ What seems to be a basic formula BUT I cant figure it out! Help,,,,Please

2014-09-29 Thread Faye dahl
Sorry I am just getting back to you. I was out of town for the weekend and tried not to check my emails for once. Thank you S​O MUCH!!! Wow I knew it was something that simple. I had everything but the = FALSE. Once again- Thank you for all of your help, I truly appreciate it! Ta-Ta for now On

Re: $$Excel-Macros$$ Report

2014-09-29 Thread joseph camill
Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi wrote: > 1. Create folder name based on "STD" - Ok > 2. Have just one pdf with all the r

Re: $$Excel-Macros$$ Report

2014-09-29 Thread Paul Schreiner
I threw it together a couple of ways. Since I don't know how comfortable you are with VBA, I modified your file to use mostly vlookups based on the student name. then, the macro simply loops through the student names, puts them on the template and generates a pdf. It was about 7% faster to do

Re: $$Excel-Macros$$ Report

2014-09-29 Thread Paul Schreiner
Absolutely this is possible. it looks like a fun exercise. do you have any experience with VBA? I'll take a look this morning and try to get back with you. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the

Re: $$Excel-Macros$$ Report

2014-09-29 Thread Vaibhav Joshi
1. Create folder name based on "STD" - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using "Offset" i suppose, Can we do a search for "Name" and then generate. - Do you want for few employees? then paste employee name in range U then report f

Re: $$Excel-Macros$$ Report

2014-09-29 Thread Vaibhav Joshi
Thank you Ashish bro.. + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:13 PM, Ashish Kumar wrote: > Hi Vaibhav Bhai, > > It's superb. > > > Regards > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >