Hello .. Need urgent help on this please.. Thanks.
On Mon, Jul 14, 2014 at 8:49 PM, pradeep palande <bunty5...@gmail.com> wrote: > Okay Pramod.. first of all Thanks for your quick response. > > I assume below is the help you needed to move forward on this topic. > > - There are 35 to 40 excels in similar format i receive every day > - I want only ID wise summary and activity wise summary from second sheet > needs to be consolidated from all these files in to one macro based fie > - my objective is to have one monthly file.. like dialy 35 files and 2 > sheets needs to be converted in one monthly file.. > > - after every days merging task - i want pivots to be prepared and > refreshed automatically... > > i hope this explains what i need at high level.. > > Let me know if you need anything specific about this.. > > Thanks.. > PP > > > On Sun, Jul 13, 2014 at 3:06 PM, Pramod Singh <pramod...@gmail.com> wrote: > >> Need more explain on this topic.....plzzz >> >> Pramod >> On 13 Jul 2014 14:48, "pradeep palande" <bunty5...@gmail.com> wrote: >> >>> Can someone help me on this please.. i am in need of this and looking >>> for solution otherwise i have to keep suffering for hours every day. thanks >>> in advance >>> >>> >>> On Sun, Jul 13, 2014 at 1:11 AM, pradeep palande <bunty5...@gmail.com> >>> wrote: >>> >>>> Hello Macro Experts, >>>> >>>> Need your help… >>>> >>>> Please see attached excel report (entered all dummy data due to >>>> confidentiality). >>>> >>>> I receive almost 80 separate reports in same format. I need you experts >>>> to help me in creating macro which will merge and pivot these reports on >>>> daily basis. >>>> >>>> Some important point for you to know before writing / helping me in >>>> creating macro. >>>> >>>> - Daily basis 30 – 40 files I receive via mail in outlook >>>> >>>> - 2 tabs needs to be merged / copied in master file >>>> >>>> - I need file name to be copied in first column >>>> >>>> - Period which is mentioned on the top of the sheet needs to >>>> be copied in second column >>>> >>>> - Activity needs to be copied in third column >>>> >>>> - Then remaining data >>>> >>>> - The 2 sheet names “op summary” and “defect summary” are >>>> consistent across the excels >>>> >>>> - Master file is having same 2 sheets with similar names >>>> where inputs from all the files needs to be copied after last row >>>> >>>> - After merging pivot table needs to be generated for sheet >>>> one (op summary) >>>> >>>> o It should have summary with >>>> >>>> o IDs in column >>>> >>>> o By activity below data points in row >>>> >>>> o Pages checked >>>> >>>> o Pages with errors >>>> >>>> o Page wise alpha errors >>>> >>>> o Page wise number errors >>>> >>>> o Accuracy >>>> >>>> Similar type of pivot for other sheet too... >>>> >>>> >>>> Let me know if anyone can help me in to this urgently… I receive these >>>> files in xls format but I am using excel 2007 which is xlsx format so macro >>>> needs to be compatible with both the formats I belive.. >>>> >>> >>> -- >>> 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.
