$$Excel-Macros$$ COMPARE AND COPYING DATA(RECORDS) WITHIN TWO EXCEL SHEETS BY COMPARING TWO MORE UNIQUE VALUES

Sir, I have two Excel sheets in which one is Master Data Sheet other one is Normaldatasheet ( here data of two is same but all the data from Master data have to updated in NormalDatasheet) *Criteria* Fields in two Sheets 1. ServiceNo(datatype-Number) 2. PolicyNo(PrimaryKey,

Re: $$Excel-Macros$$ COMPARE AND COPYING DATA(RECORDS) WITHIN TWO EXCEL SHEETS BY COMPARING TWO MORE UNIQUE VALUES

can you attach sample sheet to make work simpler.. Cheers!! On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P spvetri...@gmail.com wrote: Sir, I have two Excel sheets in which one is Master Data Sheet other one is Normaldatasheet ( here data of two is same but all the data from Master data

Re: $$Excel-Macros$$ Fwd: R Shop Data

thanks a lot guruji On Fri, Jul 18, 2014 at 9:12 PM, Vaibhav Joshi v...@vabs.in wrote: PFA excel with vba Macro!! Its more dynamic, click blue button new sheet will get created. Cheers!! On Fri, Jul 18, 2014 at 10:30 AM, my excel myxlg...@gmail.com wrote: Sir, i sent attached file

Re: $$Excel-Macros$$ Fwd: R Shop Data

thanks a lot sir On 19 July 2014 18:31, my excel myxlg...@gmail.com wrote: thanks a lot guruji On Fri, Jul 18, 2014 at 9:12 PM, Vaibhav Joshi v...@vabs.in wrote: PFA excel with vba Macro!! Its more dynamic, click blue button new sheet will get created. Cheers!! On Fri, Jul 18,

$$Excel-Macros$$ macro

Sir, i created 3 macro i want run all 3 macro at a time means macro1,macro2,macro3 macro1 for sheet2 report macro2 for sheet3 report macro3 for sheet4 report pls suggest with example sir thanks sir, Daya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ macro

Hi you can run macro thru one go by creating macro.. Sub AllMacro() Call Macro1 Call Macro2 Call Macro3 End Sub On Sat, Jul 19, 2014 at 6:41 PM, daya p princedaya2...@gmail.com wrote: Sir, i created 3 macro i want run all 3 macro at a time means macro1,macro2,macro3 macro1

RE: $$Excel-Macros$$ Using vba to open files with same name format

Hi Vaibhav, File name begins with a specific format, and yes, extension can be xls or xlsx. Like name is Nitin Report Jul 2014_07182014 Nitin Report Jul 2014_07112014 Nitin Report Jul 2014_07042014 Nitin Report Jun 2014_06252014 Thanks. Regards, Nitin Balodi Sent from my Windows Phone

RE: $$Excel-Macros$$ Using vba to open files with same name format

Hi Vaibhav, To be more specific, reports name can begin with any one out of five specific strings with dates at end in the file name convention. Please contact if you require more clarification. Thanks. Regards, Nitin Balodi Sent from my Windows Phone From:

Re: $$Excel-Macros$$ macro

Thank you Guruji On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi v...@vabs.in wrote: Hi you can run macro thru one go by creating macro.. Sub AllMacro() Call Macro1 Call Macro2 Call Macro3 End Sub On Sat, Jul 19, 2014 at 6:41 PM, daya p princedaya2...@gmail.com wrote:

Re: $$Excel-Macros$$ macro

thanks daya brother On Sat, Jul 19, 2014 at 9:46 PM, my excel myxlg...@gmail.com wrote: Thank you Guruji On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi v...@vabs.in wrote: Hi you can run macro thru one go by creating macro.. Sub AllMacro() Call Macro1 Call Macro2 Call

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

I applied the formula as you did to one cell, but now i want to apply it to a whole table as attached. I applied it to Cell C3 to be based on O, P, Q in the attached file. Now i want to apply it to the cell range from C3 to N3 and C22 to N22. Brief: the formula to apply on every row from C to N