Hi All, I am trying to make pivot table using VBA.but I am getting runtime error 5 or so. Can someone suggest me a code to make pivot cache and then table.
Thanks Abhishek Bhalla From: "amar takale"amartak...@gmail.com Sent:Thu, 25 Feb 2016 10:20:12 +0530 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ If formula Required Dear Paul Sir > >Please accept my apologies (G10 & G11 Cell). I had made an error on my >part in accidentally.And Overall formula is perfect as per mind.And this is >sumif formula & put in subject If formula also apologies for that. >Thanks again. > >Regards >Amar > > >On Wed, Feb 24, 2016 at 7:29 PM, Paul Schreiner <schreiner_p...@att.net> >wrote: >You keep mentioning an "IF" formula, but I don't see one.I'm >not sure what "test" you're expecting for an "if" >formula.It looks like you're trying to simply add the values in the two >columns (C and D)for each of the values in column B. >This can be done with the Sumif() function. >See attached. >although, you have values in rows 10 and 11 for product "AAA".Your >output seems to expect a value of 40.But I only see one previous entry of >20.00. >All the other calculations match your expectation, so I'm not sure where >the error lies. > 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 >----------------------------------------- > > On Wednesday, February 24, 2016 4:46 AM, amar takale > <amartak...@gmail.com> wrote: > > > Dear Paul Sir thanks very much for this, but if there are another (column > criteria) add in formula then how to modified IF formula?.Pls check sheet for > sampleRegradsAmarOn Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner > <schreiner_p...@att.net> wrote:In cell G4, enter > formula:=SUMIF(C$4:C4,F4,D$4:D4)and copy the formula down through column > G.The "$" means that the beginning row of the range is > "anchored" which means that the first row of each range is 4,but > the ending row of each range will increment to match the "current" > row.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----------------------------------------- On Tuesday, February > 23, 2016 8:30 AM, amar takale <amartak...@gmail.com> wrote: -- > 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 > https://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 > https://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 > https://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 https://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 https://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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
