Re: $$Excel-Macros$$ Report

2014-10-13 Thread Vaibhav Joshi
welcome bro.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 3:23 PM, joseph camill wrote: > Thank you Vaibhav > > On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi wrote: > >> Thanks bro... >> On Oct 12, 2014 6:05 PM, "Ashish Kumar"

Re: $$Excel-Macros$$ Report

2014-10-13 Thread joseph camill
Thank you Vaibhav On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi wrote: > Thanks bro... > On Oct 12, 2014 6:05 PM, "Ashish Kumar" wrote: > >> Hi Vaibhav Bhai, >> >> Nice Solution. Sheet is working Great. >> >> >> Regards >> Ashish >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Report

2014-10-12 Thread Vaibhav Joshi
Thanks bro... On Oct 12, 2014 6:05 PM, "Ashish Kumar" wrote: > Hi Vaibhav Bhai, > > Nice Solution. Sheet is working Great. > > > Regards > Ashish > > -- > 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$$ Report

2014-10-12 Thread Ashish Kumar
Hi Vaibhav Bhai, Nice Solution. Sheet is working Great. Regards Ashish -- 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 t

Re: $$Excel-Macros$$ Report

2014-10-12 Thread Vaibhav Joshi
heets and do a final check. >>> >>> >>> >>> On Fri, Oct 10, 2014 at 12:48 AM, Vaibhav Joshi wrote: >>> >>>> Joseph >>>> >>>> Did you tried this. . >>>> -- Forwarded message -- >>>> Fro

Re: $$Excel-Macros$$ Report

2014-10-10 Thread joseph camill
sheets and do a final check. >> >> >> >> On Fri, Oct 10, 2014 at 12:48 AM, Vaibhav Joshi wrote: >> >>> Joseph >>> >>> Did you tried this. . >>> ------ Forwarded message -- >>> From: "Vaibhav Joshi"

Re: $$Excel-Macros$$ Report

2014-10-10 Thread Vaibhav Joshi
add more sheets and do a final check. > > > > On Fri, Oct 10, 2014 at 12:48 AM, Vaibhav Joshi wrote: > >> Joseph >> >> Did you tried this. . >> -- Forwarded message -- >> From: "Vaibhav Joshi" >> Date: Oct 7, 2014 10

Re: $$Excel-Macros$$ Report

2014-10-09 Thread joseph camill
eph > > Did you tried this. . > -- Forwarded message -- > From: "Vaibhav Joshi" > Date: Oct 7, 2014 10:51 AM > Subject: Re: $$Excel-Macros$$ Report > To: "excel-macros@googlegroups.com" > Cc: > > JC > > check this, > >

Re: $$Excel-Macros$$ Report

2014-10-09 Thread joseph camill
Hi Vaibhav, Thank you for the file and apologies for the late response. It is working great. Thanks and regards, Joseph Camill On Tue, Oct 7, 2014 at 10:51 AM, Vaibhav Joshi wrote: > JC > > check this, > > there is sheet name C, in that mention InputSheet Names in col A & > OutPutsheet name

Re: $$Excel-Macros$$ Report

2014-10-06 Thread joseph camill
Hi Vaibhav, In addition, the format for Std IX and X will change in terms of marks display. Regards, Joseph On Oct 7, 2014 10:15 AM, "joseph camill" wrote: > Hi Vaibhav, > > Output format remains the same but there is addition / subtraction of > subjects and off course student name will change

Re: $$Excel-Macros$$ Report

2014-10-06 Thread joseph camill
Hi Vaibhav, Output format remains the same but there is addition / subtraction of subjects and off course student name will change. Thanks, Joseph On Oct 7, 2014 9:53 AM, "Vaibhav Joshi" wrote: > Are output for individual Std is diff? > > + > *I did not do this for you. God is here working

Re: $$Excel-Macros$$ Report

2014-10-06 Thread Vaibhav Joshi
Are output for individual Std is diff? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 12:37 AM, joseph camill wrote: > Hi Vaibhav, > > To clarify further, I will have multiple RAW sheets, the current example > shows STD IV, so I will have 10 su

Re: $$Excel-Macros$$ Report

2014-10-06 Thread joseph camill
Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet name RAW, I may have the sheet name as "STD_I", "STD_II", etc. until "STD_X" and similarly 10 Final sheets. So inste

Re: $$Excel-Macros$$ Report

2014-10-06 Thread joseph camill
Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi wrote: > chk this... > > Goto main sheet & press button to run macro! > > + > *I did not do this for you. God is here working through me for you.* > > On Mon, Oct 6,

Re: $$Excel-Macros$$ Report

2014-10-06 Thread joseph camill
Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi wrote: > For X=3 is not counting sheets!! It is begining selecting sheets from > sheet #3 onwards..Check module PDFActiveSheet_Consol() > > will share dynamic code which can enable you to sel

Re: $$Excel-Macros$$ Report

2014-10-06 Thread Vaibhav Joshi
For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names & adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here w

Re: $$Excel-Macros$$ Report

2014-10-06 Thread joseph camill
Hi Vaibhav, I think the end loop i.e. "For x = 3 …" is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying "RAW" and "Final" in the code. This works if there are only

Re: $$Excel-Macros$$ Report

2014-10-06 Thread Vaibhav Joshi
what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill wrote: > Hi Vaibhav, > > Thank you for the clarification. Is there any chance to get the other > request, if possible. > > Thanks, > Joseph > > On Mon, O

Re: $$Excel-Macros$$ Report

2014-10-06 Thread joseph camill
Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi wrote: > Hi, > > You have 2 sheets in this excel workbook, > > > I am creating new sheets after sheet 2 for each students, once

Re: $$Excel-Macros$$ Report

2014-10-05 Thread Vaibhav Joshi
Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.*

Re: $$Excel-Macros$$ Report

2014-10-05 Thread joseph camill
Hi Vaibhav, I think the end loop i.e. "For x = 3 …" is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying "RAW" and "Final" in the code. This works if there are only

Re: $$Excel-Macros$$ Report

2014-10-05 Thread joseph camill
Hi Vaibhav, Can you please explain the last loop in the code "For x = 3 …" part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi wrote: > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Sep 30, 2014 at 4:44 AM, joseph camill > wrote: > >> Hi

Re: $$Excel-Macros$$ Report

2014-09-30 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill wrote: > 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

Re: $$Excel-Macros$$ Report

2014-09-29 Thread joseph camill
> *To:* "excel-macros@googlegroups.com" > *Sent:* Friday, September 26, 2014 6:40 PM > *Subject:* $$Excel-Macros$$ Report > > Hi, > > I am working on a project where I need to print 100 report card at a time > either directly to a printer or as PDF. > >

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

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$$ 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
Friday, September 26, 2014 6:40 PM >Subject: $$Excel-Macros$$ Report > > > >Hi, > > >I am working on a project where I need to print 100 report card at a time >either directly to a printer or as PDF. > > >Attached is the example workbook. All my data will be

Re: $$Excel-Macros$$ Report

2014-09-29 Thread Paul Schreiner
r 26, 2014 6:40 PM >Subject: $$Excel-Macros$$ Report > > > >Hi, > > >I am working on a project where I need to print 100 report card at a time >either directly to a printer or as PDF. > > >Attached is the example workbook. All my data will be entered in sheet

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 >

Re: $$Excel-Macros$$ Report

2014-09-28 Thread Ashish Kumar
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 =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

Re: $$Excel-Macros$$ Report

2014-09-28 Thread joseph camill
Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on "STD" 2. Have just one pdf with all the reports. 3. Right now it is generating the name using "Offset" i suppose, Can we do a search for "Name" and then generate. On Sun

Re: $$Excel-Macros$$ Report

2014-09-28 Thread joseph camill
Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill wrote: > Hi Vaibhav, > > Thank you for the solution. I will check it and get back to you. >

Re: $$Excel-Macros$$ Report

2014-09-28 Thread joseph camill
Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, "Vaibhav Joshi" wrote: > Hey > > Chek attachment, just click on blue button & folder name Test will be > created on desktop & report card will be saved name wise in P

Re: $$Excel-Macros$$ Report

2014-09-27 Thread Vaibhav Joshi
Hey Chek attachment, just click on blue button & folder name Test will be created on desktop & report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Chee

$$Excel-Macros$$ Report

2014-09-26 Thread joseph camill
Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named "Raw" and my output should look like sheet named "Final". Is it possible to print it to PDF / printer

RE: $$Excel-Macros$$ Report (needs to be formatted)

2013-06-13 Thread Manjunath Narayanappa
-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report (needs to be formatted) Yes. a) Excel will color the cell in a column whenever the value meets your criteria, irrespective of what is happening in the other two columns. b) Excel will color all three columns only when values in all three

Re: $$Excel-Macros$$ Report (needs to be formatted)

2013-06-13 Thread Abhishek Jain
Behalf Of *Manjunath Narayanappa > *Sent:* 13 June 2013 11:00 > *To:* 'excel-macros@googlegroups.com' > *Subject:* RE: $$Excel-Macros$$ Report (needs to be formatted) > > > > Dear Priti, > > > > I required formula , so that when these 3 criteria appea

RE: $$Excel-Macros$$ Report (needs to be formatted)

2013-06-13 Thread Manjunath Narayanappa
Dear Priti, Can we use conditional formatting for this Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 13 June 2013 11:00 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Report (n

RE: $$Excel-Macros$$ Report (needs to be formatted)

2013-06-13 Thread Manjunath Narayanappa
Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of priti verma Sent: 13 June 2013 08:50 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report (needs to be formatted) little

Re: $$Excel-Macros$$ Report (needs to be formatted)

2013-06-13 Thread priti verma
omeone help me on the below. > > > > Thanks > > Manjunath > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Manjunath Narayanappa > *Sent:* 12 June 2013 16:13 > *To:* 'excel-macros@googlegroups

$$Excel-Macros$$ Report Problem in MS Access

2012-05-03 Thread Rakesh Joshi
Hi Ashsih , and Concern Person. i Have package in MS Access which i need to take print out as per the PDF. for this what i am doing i have blank form in pdf so i have pasted the same in report disign view and convert into image. and then setting all text boxes and their control. becouse i dont h

$$Excel-Macros$$ Report Generation

2011-09-07 Thread Shankar Bheema
What is the procedure to develop reports basing on the excel database through UserForm. Report generation in the sense, not in column and rows. It would be look like a form in word document. -- -- Some important lin

Re: $$Excel-Macros$$ Report generation for Excel 2003

2011-09-05 Thread dguillett1
You could maybe use a macro or a simple vlookup formula From: Shankar Bheema Sent: Monday, September 05, 2011 8:13 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report generation for Excel 2003 I am attaching the VBA project and a sample spreadsheet form. I want build a

Re: $$Excel-Macros$$ Report generation for Excel 2003

2011-09-05 Thread rajan verma
hi, what type of report do you need to create, which is your database.. please provide description about that.. On Mon, Sep 5, 2011 at 4:13 PM, Bheema Shankar wrote: > Hai all gurus. > > Good evening. I heard that excel is having Report generation option > for its database. May I have the add-i

$$Excel-Macros$$ Report generation for Excel 2003

2011-09-05 Thread Bheema Shankar
Hai all gurus. Good evening. I heard that excel is having Report generation option for its database. May I have the add-in to build report for my database ? Hope your kind support for me. -- -- Some important link