Your example doesn't make sense... can you put a sample excel sheet of what the data looks like in table and how you want it
On Jun 17, 5:00 pm, satish <satishpag...@gmail.com> wrote: > Dear Group members > I feel the following query is challenging. Is it possible to find a solution > without macro (as am weak in macro) > > Situation. > > There is data in table format with "m" columns and "n" rows with same column > and row headings. > > There are 100s of similar tables which represent data of different dates. > > E.g. of one table > > Date : 17/06/2009 > > 1st bucket > > 2nd bucket > > 3rd bucket > > 4th bucket > > Deposit > > 200 > > 300 > > 400 > > 500 > > Call money > > 56 > > 43 > > 35 > > 54 > > borrowings > > 353 > > 35 > > 353 > > 35 > > loans > > 545 > > 424 > > 4545 > > 666 > > investment > > 242 > > 55 > > 66 > > 33 > > asset > > 66 > > 36 > > 64 > > 7 > > Now i want to consolidate all 100s of tables, in following table format, > > Deposit > > Call money > > Borrowing > > Loan > > investment > > asset > > 1st bucket > > 2nd bucket > > 3rd bucket > > 4th bucket > > 1st bucket > > 2nd bucket > > 3rd bucket > > 4th bucket > > 1st bucket > > 2nd bucket > > 3rd bucket > > 4th bucket > > 1st bucket > > 2nd bucket > > 3rd bucket > > 4th bucket > > 1st bucket > > 2nd bucket > > 3rd bucket > > 4th bucket > > 1st bucket > > 2nd bucket > > 3rd bucket > > 4th bucket > > 17/06/2009 > > 18/06/2009 > > 19/06/2009 > > 20/06/2009 > > 21/06/2009 > > 22/06/2009 > > 23/06/2009 > > 24/06/2009 > > 25/06/2009 > > 26/06/2009 > > 27/06/2009 > > Please note that the *date is given* *as the heading in the original table*. > > I hope early response will be received from the excel experts in the group. > > -- > Satish P N > Asst. Manager > South Indian Bank --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
