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

2014-10-06 Thread Vaibhav Joshi
Hey Sanjay.. warm welcome.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Oct 5, 2014 at 11:07 PM, sanjay kumar sanjay.kr2...@gmail.com wrote: hello, My name is Sanjay and I work at HCL in Noida. I use Excel, VBA and some other tools for daily

Re: $$Excel-Macros$$ Report

2014-10-06 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$$ Re: Introduce Yourself !!

2014-10-06 Thread Chandru
Hello All, I Am Chandru from Chennai and I work at Logitek. Regards, Chandru On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Sanjay.. warm welcome.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Oct 5, 2014 at 11:07

Re: $$Excel-Macros$$ Refresh BackgroundQuery:=False doesn't work

2014-10-06 Thread Vaibhav Joshi
check this... its working for me. but lil time consuming.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Oct 5, 2014 at 9:58 PM, Nur Hossain nur2...@gmail.com wrote: Dear all , I was using attached macro since last few months . and I didn’t get

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 v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each

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 joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks,

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

2014-10-06 Thread Vaibhav Joshi
Warm welcome Chandru!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:22 PM, Chandru chandr...@gmail.com wrote: Hello All, I Am Chandru from Chennai and I work at Logitek. Regards, Chandru On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav

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

2014-10-06 Thread Ashish Kumar
Welcome Chandru. 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 titles, like

Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS

2014-10-06 Thread Paul Schreiner
I can probably handle explaining Vlookup and Hlookup, but to teach macros??? That's what this group is for! The techniques of using macros is a subject about which many books have been written and thousands (and thousands) of emails have been shared. There's really no single way to teach

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 2

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

$$Excel-Macros$$ Sort VBA required

2014-10-06 Thread amar takale
Dear all experts I required VBA code for sorting.pls see with detailed in excel. Regards Amar -- 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)

Re: $$Excel-Macros$$ Sort VBA required

2014-10-06 Thread Paul Schreiner
I'm not sure about your requirement. You SAY you want to sort, but what you're describing is a filter. Sorting implies a change in sequence, Filter implies hiding rows that do not meet specific criteria. And... why would it matter if a stock appears in both categories? Even if you were

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 v...@vabs.in 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

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 v...@vabs.in 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,

Re: $$Excel-Macros$$ Refresh BackgroundQuery:=False doesn't work

2014-10-06 Thread Nur Hossain
Dear Joshi Da,Yes it works perfectly ! . little bit time consuming . but no issue . thanks for your valuable time.. On 10/6/14, Vaibhav Joshi v...@vabs.in wrote: check this... its working for me. but lil time consuming.. Cheers!! + *I did not do this for you. God is here working

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 instead of

$$Excel-Macros$$ Help!

2014-10-06 Thread Joe Coldwell
Hi everone, I've been trying to figure out how to do this for a few days now, and decided to ask for help. I want to make a button macro that, when you click it, it displays a value of a cell in a diferent cell, and each time you click it it displays the cell below. *In other words:* I want

$$Excel-Macros$$ Re: Help!

2014-10-06 Thread Joe Coldwell
I apologize for not following forum rules, I just read them :( Any thread in the future I will make sure is formatted correctly. -- 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$$ Help!

2014-10-06 Thread Ricardo®
Is an example: considering sheet1: Sub TestButton() Dim sht1 As Worksheet Dim lastRow As Long Set sht1 = Sheets(1) lastRow = sht1.Cells(Rows.Count, 2).End(xlUp).Row + 1 sht1.Range(b lastRow) = sht1.[a1] End Sub rgds. Basole 2014-10-06 16:39 GMT-03:00 Joe Coldwell

Re: $$Excel-Macros$$ Help!

2014-10-06 Thread Vaibhav Joshi
Joe, Here you go.. check this attachment. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 1:09 AM, Joe Coldwell josephcoldw...@gmail.com wrote: Hi everone, I've been trying to figure out how to do this for a few days now, and

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 joseph.cam...@gmail.com wrote: Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV,

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 v...@vabs.in wrote: Are output for individual Std is diff? + *I did not do this for you. God is here

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 joseph.cam...@gmail.com wrote: Hi Vaibhav, Output format remains the same but there is addition / subtraction of subjects and off course