Try this...
Press Alt + F8 & Run macro, on prompt enter date for which you are updating data..macro will copy data from daily data sheet to main sheet... Cheers!! On Mon, Mar 2, 2015 at 3:53 PM, Dhaval Shah <todhavals...@gmail.com> wrote: > ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? > > Warm Regards, > > Dhaval Shah > M) 98240 35253 > *E-mail : todhavals...@gmail.com <todhavals...@gmail.com>* > > > > On Mon, Mar 2, 2015 at 3:52 PM, Dhaval Shah <todhavals...@gmail.com> > wrote: > >> THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I >> UPDATE ITS PASTE WRONGLY >> >> Warm Regards, >> >> Dhaval Shah >> M) 98240 35253 >> *E-mail : todhavals...@gmail.com <todhavals...@gmail.com>* >> >> >> >> On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth <michaelvino...@gmail.com >> > wrote: >> >>> Hi Dhaval Shah, >>> >>> Please find the attached macro file. >>> >>> Regards, >>> MV >>> >>> On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote: >>>> >>>> Dear Friends >>>> >>>> Pls find attached file of my work >>>> >>>> In sheet two sheets one is main sheet & another is daily data >>>> >>>> in main sheet yellow mark is the difference of two dates i want to do >>>> this automatic becuase @ present i do it mannual and its taking too much >>>> time pls give me suggestion >>>> >>>> >>>> Warm Regards, >>>> >>>> Dhaval Shah >>>> M) 98240 35253 >>>> *E-mail : todhav...@gmail.com* >>>> >>>> >>>> -- >>> 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.
participant wise.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
