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$$ 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 wrote: > Hi everone, I've been trying to figure out how to do this for a few days > now, and decided to ask for help. > >

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 : >

$$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 @ https://www.facebook.c

$$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 t

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$$ 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 wrote: > check this... > > its working for me. but lil time consuming.. > > Cheers!! > > + > *I did not do this for you. God is here working through m

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$$ 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 sorti

$$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) U

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$$ 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 ma

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 P

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 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 Joshi wrote: >

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$$ 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 wrote: > Dear all , I was using attached macro since last few months . and I didn’t > get any problem . bu