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 problem.
Cheers!! On Tue, Jun 17, 2014 at 4:18 PM, Jocky Beta <jocky6...@gmail.com> wrote: > Hi every time I received new sheet from my colleague in. That > situation your sheet not working > > Regards > > On 6/17/14, Vaibhav Joshi <v...@vabs.in> wrote: > > I didnt get you what you are trying to say! > > > > > > > > > > On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta <jocky6...@gmail.com> > 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 solution on this > >> > >> Regards > >> > >> On 6/17/14, Vaibhav Joshi <v...@vabs.in> wrote: > >> > Hi > >> > > >> > Use this file. > >> > > >> > Cheers!! > >> > > >> > > >> > On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi <v...@vabs.in> wrote: > >> > > >> >> > >> >> 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 > column > >> >> A > >> >> e.g. cell A8 & value will be fetched. > >> >> > >> >> Hope it helps. > >> >> > >> >> Cheers!! > >> >> > >> >> > >> >> On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta <jocky6...@gmail.com> > >> wrote: > >> >> > >> >>> 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 <v...@vabs.in> wrote: > >> >>> > Hey > >> >>> > > >> >>> > How do you want to fetch? Formula or Macro? > >> >>> > > >> >>> > > >> >>> > > >> >>> > > >> >>> > On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta <jocky6...@gmail.com > > > >> >>> 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 > >> >>> >> > >> >>> >> Regards > >> >>> >> > >> >>> >> -- > >> >>> >> 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 > >> >>> >> Please > >> >>> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > >> >>> >> Advice > >> >>> >> will not get quick attention or may not be answered. > >> >>> >> 2) Don't post a question in the thread of another member. > >> >>> >> 3) Don't post questions regarding breaking or bypassing any > >> >>> >> security > >> >>> >> measure. > >> >>> >> 4) Acknowledge the responses you receive, good or bad. > >> >>> >> 5) Jobs posting is not allowed. > >> >>> >> 6) Sharing copyrighted material and their links is not allowed. > >> >>> >> > >> >>> >> NOTE : Don't ever post confidential data in a workbook. Forum > >> >>> >> owners > >> >>> and > >> >>> >> members are not responsible for any loss. > >> >>> >> --- > >> >>> >> You received this message because you are subscribed to the > Google > >> >>> Groups > >> >>> >> "MS EXCEL AND VBA MACROS" group. > >> >>> >> To unsubscribe from this group and stop receiving emails from it, > >> >>> >> send > >> >>> an > >> >>> >> email to excel-macros+unsubscr...@googlegroups.com. > >> >>> >> To post to this group, send email to > >> >>> >> excel-macros@googlegroups.com. > >> >>> >> Visit this group at http://groups.google.com/group/excel-macros. > >> >>> >> For more options, visit https://groups.google.com/d/optout. > >> >>> >> > >> >>> > > >> >>> > -- > >> >>> > 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 > >> >>> > Please > >> >>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > >> >>> > Advice > >> >>> will > >> >>> > not get quick attention or may not be answered. > >> >>> > 2) Don't post a question in the thread of another member. > >> >>> > 3) Don't post questions regarding breaking or bypassing any > >> >>> > security > >> >>> > measure. > >> >>> > 4) Acknowledge the responses you receive, good or bad. > >> >>> > 5) Jobs posting is not allowed. > >> >>> > 6) Sharing copyrighted material and their links is not allowed. > >> >>> > > >> >>> > NOTE : Don't ever post confidential data in a workbook. Forum > >> >>> > owners > >> >>> and > >> >>> > members are not responsible for any loss. > >> >>> > --- > >> >>> > You received this message because you are subscribed to the Google > >> >>> Groups > >> >>> > "MS EXCEL AND VBA MACROS" group. > >> >>> > To unsubscribe from this group and stop receiving emails from it, > >> send > >> >>> an > >> >>> > email to excel-macros+unsubscr...@googlegroups.com. > >> >>> > To post to this group, send email to > excel-macros@googlegroups.com. > >> >>> > Visit this group at http://groups.google.com/group/excel-macros. > >> >>> > For more options, visit https://groups.google.com/d/optout. > >> >>> > > >> >>> > >> >>> -- > >> >>> 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 > >> >>> Please > >> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > >> >>> Advice > >> >>> will not get quick attention or may not be answered. > >> >>> 2) Don't post a question in the thread of another member. > >> >>> 3) Don't post questions regarding breaking or bypassing any security > >> >>> measure. > >> >>> 4) Acknowledge the responses you receive, good or bad. > >> >>> 5) Jobs posting is not allowed. > >> >>> 6) Sharing copyrighted material and their links is not allowed. > >> >>> > >> >>> NOTE : Don't ever post confidential data in a workbook. Forum > owners > >> >>> and > >> >>> members are not responsible for any loss. > >> >>> --- > >> >>> You received this message because you are subscribed to the Google > >> >>> Groups > >> >>> "MS EXCEL AND VBA MACROS" group. > >> >>> To unsubscribe from this group and stop receiving emails from it, > >> >>> send > >> >>> an > >> >>> email to excel-macros+unsubscr...@googlegroups.com. > >> >>> To post to this group, send email to excel-macros@googlegroups.com. > >> >>> Visit this group at http://groups.google.com/group/excel-macros. > >> >>> For more options, visit https://groups.google.com/d/optout. > >> >>> > >> >> > >> >> > >> > > >> > -- > >> > 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 > Please > >> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice > >> will > >> > not get quick attention or may not be answered. > >> > 2) Don't post a question in the thread of another member. > >> > 3) Don't post questions regarding breaking or bypassing any security > >> > measure. > >> > 4) Acknowledge the responses you receive, good or bad. > >> > 5) Jobs posting is not allowed. > >> > 6) Sharing copyrighted material and their links is not allowed. > >> > > >> > NOTE : Don't ever post confidential data in a workbook. Forum owners > >> > and > >> > members are not responsible for any loss. > >> > --- > >> > You received this message because you are subscribed to the Google > >> > Groups > >> > "MS EXCEL AND VBA MACROS" group. > >> > To unsubscribe from this group and stop receiving emails from it, send > >> > an > >> > email to excel-macros+unsubscr...@googlegroups.com. > >> > To post to this group, send email to excel-macros@googlegroups.com. > >> > Visit this group at http://groups.google.com/group/excel-macros. > >> > For more options, visit https://groups.google.com/d/optout. > >> > > >> > >> -- > >> 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 Please > >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > >> will not get quick attention or may not be answered. > >> 2) Don't post a question in the thread of another member. > >> 3) Don't post questions regarding breaking or bypassing any security > >> measure. > >> 4) Acknowledge the responses you receive, good or bad. > >> 5) Jobs posting is not allowed. > >> 6) Sharing copyrighted material and their links is not allowed. > >> > >> NOTE : Don't ever post confidential data in a workbook. Forum owners > and > >> members are not responsible for any loss. > >> --- > >> You received this message because you are subscribed to the Google > Groups > >> "MS EXCEL AND VBA MACROS" group. > >> To unsubscribe from this group and stop receiving emails from it, send > an > >> email to excel-macros+unsubscr...@googlegroups.com. > >> To post to this group, send email to excel-macros@googlegroups.com. > >> Visit this group at http://groups.google.com/group/excel-macros. > >> For more options, visit https://groups.google.com/d/optout. > >> > > > > -- > > 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 Please > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material and their links is not allowed. > > > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > > members are not responsible for any loss. > > --- > > You received this message because you are subscribed to the Google Groups > > "MS EXCEL AND VBA MACROS" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to excel-macros+unsubscr...@googlegroups.com. > > To post to this group, send email to excel-macros@googlegroups.com. > > Visit this group at http://groups.google.com/group/excel-macros. > > For more options, visit https://groups.google.com/d/optout. > > > > -- > 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 Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
