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

2014-07-31 Thread VETRI S P
Sir, In this regard, for better understanding , I would like to inform the following 1) We are in receipt of Monthly Premium recovery schedules in r/o employees of our client(like insurance company). 2) In that schedule the following fields are inclueded( Sl No, ServiceNo, PolicyNo, Premi

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

2014-07-21 Thread Vaibhav Joshi
Ok, can you explain one example too for better inderstanding... Cheers!! On Mon, Jul 21, 2014 at 2:02 PM, VETRI S P wrote: > > > On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote: >> >> can you attach sample sheet to make work simpler.. >> >> Cheers!! >> > > Sir, > > Sample File att

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

2014-07-21 Thread VETRI S P
Sir, Sample file is here Regards On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote: > > can you attach sample sheet to make work simpler.. > > Cheers!! > > > On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P > wrote: > >> >> >> Sir, >> >> >> I have two Excel sheets in which one is Master Da

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

2014-07-21 Thread VETRI S P
On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote: > > can you attach sample sheet to make work simpler.. > > Cheers!! > Sir, Sample File attached Pl find a way to compare and copying data within sheets > > On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P > wrote: > >> >> >> Sir, >

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

2014-07-18 Thread Vaibhav Joshi
can you attach sample sheet to make work simpler.. Cheers!! On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P 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 have to updat

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

2014-07-18 Thread VETRI S P
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, Alp