Dear André Luiz D´Avila, Thanks for giving your valuable time for giving reply on my post. But what you replied is very simple and known to be but not useful as because: - 1. The examplese (i.e. columns) in both purchase & sale sheet will be more than 50 per sheets. and that too different from each other. 2. What you will do when you have 5000 nos. of purchases and more than 2 000 invoices of sale. Then you will not keep one sheet for both the transactions.
I have prepared a very well planned excel program to monitor automatically all the finance / tax & accounts related work and my nos of sheets are very high. I want to minimize this by way of getting consolidated report through pivot. Thanks once again. BS On Friday, March 13, 2015 at 7:59:51 PM UTC+5:30, André D'Avila wrote: > > Hello, > You have a excel sheet with table "purchase" and other one with "Sales". > > In order to combine both of them, the fast way is to create a 3 sheet. > > In that third one, create another table. Paste de "purchase table" and > below paste the Sales table. > > After that create a Pivot using this new table. I recommend to create a > macro to copy and paste each table constantly. > > I attached an exemple. > > > > André Luiz D´Avila > > 2015-03-13 10:41 GMT-03:00 B Sharma <sharm...@gmail.com <javascript:>>: > >> Dear All Excel Experts, >> From a very long time, I am trying to create a pivot table using two or >> more tables, but not getting appropriate results. >> >> Please help me , if anybody has ever done so. >> >> For e.g. in one table there are purchase details and in another column >> there are sale details.. >> >> I want a combined pivot table which can show both the details at once >> with showing closing balances. >> >> A small database is attached for your reference. >> I have searched a lot. The reference website is also not as per my needs >> as pivot table can be created but the result cannot be merged. >> Thanks in advance. >> >> >> BS >> ------------------------------ >> Consolidate multiple worksheets into one PivotTable report >> <https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5> >> >> -- >> 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...@googlegroups.com <javascript:>. >> To post to this group, send email to excel-...@googlegroups.com >> <javascript:>. >> 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.
