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"
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
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 @
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
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
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"
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
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,
>
>
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
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
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
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
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
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,
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
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
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
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
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
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.*
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
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
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
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
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
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
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
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
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
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
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
>
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
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
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.
>
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
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
-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
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
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
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
little more explanation would be great to give answer quickly,
do you need data validation or formula, can you explain last point
specially ?
On Thu, Jun 13, 2013 at 1:16 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear Experts,
>
>
>
> Can someone help me on the below
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
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
43 matches
Mail list logo
