The problem seems to be that in your workbook Company_Reval.xlsm, your consolidated sheet is missing column headings in column N and O All columns in your pivot table have to have column headings. looking a bit closer, it looks like your new file is missing the City column from column J, which then shifted the Zip/phone/shipVia/Company columns. it's allso missing the "HS" column. adding the necessary column headings should fix your problem.
Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- >________________________________ > From: Laxmanan M <laxflyflow...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Monday, October 27, 2014 6:49 AM >Subject: $$Excel-Macros$$ Issue while using vba for pivot table data's > > > >Dear Masters, >i have 2 workbooks one is old and another one is new workbook.Ususally we are >doing pivot table to customize the data for consolidation. >But now we have used macro to customize the datas.we have old workbook which >has a macro in that and it was working fine.But now we made some changes in >the new workbook .But when apply the same code we are getting error >Old workbook Name:customer.Xlsm >New workbook name:customer workbook_reval.Xlsm >I have attached the two workbooks.Now i need to run the macro in new workbook >using same concept of the old workbook code >I'm Pulling my hair out from morning..I dint able to solve the issue. >Kindly help me on the same >Lax -- >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.
