Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Vaibhav Joshi
Hi Try second file which i sent today, pl note..either data structure or heading should be unique.. I have prepared second sheet assuming data structure will be same..For working 1st file you need to have same headings in both input & output file. Do let me know where exactly you are finding probl

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
Hi every time I received new sheet from my colleague in. That situation your sheet not working Regards On 6/17/14, Vaibhav Joshi wrote: > I didnt get you what you are trying to say! > > > > > On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta wrote: > >> Hi, >> >> Thanks for the providing me the solu

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Vaibhav Joshi
I didnt get you what you are trying to say! On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta wrote: > Hi, > > Thanks for the providing me the solution. But I received sheet 1 file > on daily basic in new sheet in that case this file is not working. it > would be very helpful if you provide me sol

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
Hi, Thanks for the providing me the solution. But I received sheet 1 file on daily basic in new sheet in that case this file is not working. it would be very helpful if you provide me solution on this Regards On 6/17/14, Vaibhav Joshi wrote: > Hi > > Use this file. > > Cheers!! > > > On Tue, Ju

Re: $$Excel-Macros$$ Data Fetching

2014-06-16 Thread Vaibhav Joshi
HI Since date format is not the same excel can search directly what you want, however macro in attached sheet can help you to fetch data one by one. You need to keep open sheet 1 & sheet 2 (Only 2 sheets). Goto sheet 2 workbook, hit that blue button & select the date which is in sheet one in colum

Re: $$Excel-Macros$$ Data Fetching

2014-06-16 Thread Jocky Beta
Hi vaibhav, Fist upon thanks for the reply. I will prefer both the way It would be very helpful If u help me on the same. Regards On 6/16/14, Vaibhav Joshi wrote: > Hey > > How do you want to fetch? Formula or Macro? > > > > > On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta wrote: > >> Hi Team, >

Re: $$Excel-Macros$$ Data Fetching

2014-06-16 Thread Vaibhav Joshi
Hey How do you want to fetch? Formula or Macro? On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta wrote: > Hi Team, > > I want to fetch data from one sheet to another sheet by referring the > data, Attached sheet will explain you what i want exactly. > > Request all of you to kindly help me on th

Re: $$Excel-Macros$$ Data Fetching

2014-06-16 Thread Jocky Beta
Hi Team, Your valuable replay on this will be appreciated. Regards On 6/15/14, Jocky Beta wrote: > Hi Team, > > I want to fetch data from one sheet to another sheet by referring the data, > Attached sheet will explain you what i want exactly. > > Request all of you to kindly help me on this > >