$$Excel-Macros$$ How to replace a macro in all sheets

2015-10-22 Thread Pravin Gunjal
Hi Friend pl help me out to replace a macro in all sheets of the same file. Or any other solution may welcome. Thanks Pravin Gunjal On Oct 22, 2015 1:09 PM, "Pravin Gunjal" wrote: > Can anyone help me on this issue plz. > On Oct 21, 2015 3:26 PM, "Pravin Gunjal" wrote: > >> Hi Mandeep >> >> The

Re: $$Excel-Macros$$ Task Scheduler

2015-10-22 Thread Chandra Shekar
Hello Paul, Am trying to run excel from task scheduler which as macro in it here I need to run task scheduler from 10:00 AM - 6:00 PM(except weekends) At present I have scheduled it from task scheduler and its working fine what I need is it should run from 10:00 AM - 6:00 PM only. Regards, Ch

Re: $$Excel-Macros$$ Finding maximum combinations

2015-10-22 Thread srav anthi
Ideally if I should be able to see in a different column which two or three numbers to combine to maximize the output. Result should show me which numbers I need to pair to get anything in between 0 to 1200. A B 870 1 321 1 354 2 836 2 355 3 835 3 345 4 412 4 428 4 896 5 280 5 341 6 380 6 406

Re: $$Excel-Macros$$ Finding maximum combinations

2015-10-22 Thread srav anthi
Hi Paul Firstly thank you for taking time out Yes I am new to excel and never used macros but I am happy to use Macro and other issue is I don't know how to write VBA codes... Steps I am following manually is sort data highest to lowest and pair lowest number and highest number 360+800=1160,

Re: $$Excel-Macros$$ VBA code for delete duplicate rows

2015-10-22 Thread Paul Schreiner
yes...that's how it works. You record a macro in which you go through the steps.You then customize the hard-coded values to use variables or values that will work in future executions of the macro. I recorded a macro that deleted duplicates from 3 columns and 170,702 rows. It gave me:    ActiveS

Re: $$Excel-Macros$$ How to apply multiple filters based on multiple criteria

2015-10-22 Thread mani bolla
Hi Paul, Is any update on requested problem statement, Kindly help us. Regards Mani On Sunday, 18 October 2015 20:44:41 UTC+5:30, mani bolla wrote: > > Hi Paul, > > Thanks a ton for your help, Code not satisfying below object. > > if values in the criteria sheet not found in raw data sheet , val

Re: $$Excel-Macros$$ VBA code for delete duplicate rows

2015-10-22 Thread mani bolla
Hi paul, i tried , but i am looking for a code, so i can customize , if i recorded with macro i may get hard code values. Request you to provide code. Regards Mani On Thu, Oct 22, 2015 at 11:28 PM, Paul Schreiner wrote: > Have you tried recording a macro and then using "Remove Duplicates" fro

Re: $$Excel-Macros$$ VBA code for delete duplicate rows

2015-10-22 Thread Paul Schreiner
Have you tried recording a macro and then using "Remove Duplicates" from the Data tab? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long

$$Excel-Macros$$ VBA code for delete duplicate rows

2015-10-22 Thread mani bolla
Hi All, Request you to provide VBA code for delete duplicate rows Data before delete duplicate rows Name Subject Marks Ravi Maths 90 Rahul Physics 85 Raju Science 75 Raju Science75 Ravi Maths 90 Data after deleting duplicate

Re: $$Excel-Macros$$ Finding maximum combinations

2015-10-22 Thread Paul Schreiner
What kind of solution are you looking for?You said you're new to Excel, so does that mean you're not comfortable working with VBA macro programming? You said you're doing it "manually".How?what steps do you go through?What do you want the end result to look like? Paul

Re: $$Excel-Macros$$ Re: Getting Run time error for macro

2015-10-22 Thread Pravin Gunjal
Can anyone help me on this issue plz. On Oct 21, 2015 3:26 PM, "Pravin Gunjal" wrote: > Hi Mandeep > > The code you have replaced in this mail​ has to be replaced in other > sheets also of the same file.. file is attached for your immediate > reference. > > Pl help me out on this. > > Thanks, > P

$$Excel-Macros$$ Finding maximum combinations

2015-10-22 Thread srav anthi
Hi every one I am new to this form and new to excel as well... I need some help hopping some one can help me out If a column lets say "A" has numbers ranging from 200 to 1200 I want to find out if any two or three combinations of numbers can find sum of 1200 or under... this is to maximize the sh