Announcement

Collapse
No announcement yet.

reverse pivot table, combine all properties and accounts USD $15.00

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • reverse pivot table, combine all properties and accounts USD $15.00



    Hi - my accounting system spits out account statements for every property on its own tab, with a workbook of properties that can be many tabs in length. Every property's name is in cell A5 for every tab of the worksheet. I need a macro to convert the the data to columnar format where there would 3 columns with property name, account description, and date. Then for all the data from every tab would be combined into these 3 column names in a single tab - where I could make a pivot table to better analyze all the data.

    Any help would be very much appreciated!

    Attached Files

  • #2
    Would you show an short example of what the results would look like for some of the data in your workbook.
    Alan

    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

    If someone has helped you, say "thank you" by clicking on the Like Button.

    Comment


    • #3
      Alan, are you taking this job? If not I am willing to do it

      Comment


      • #4
        No problem - here is an example sample final output of what I would love to see. I meant 4 column output: property name (in cell A5), account name, month, and amount. (see attached).
        Attached Files

        Comment


        • #5
          trunten; you take it. I am only interested in getting the right info out there that will allow someone to answer.
          Alan

          Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
          FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

          If someone has helped you, say "thank you" by clicking on the Like Button.

          Comment


          • #6
            ok thanks.
            Slectha, I will PM you with the solution.

            Comment


            • #7
              Hi Slechta, did you get my message?

              Comment


              • #8


                I just got it. Thank you so much!! amazing work. check your email/messages.

                Comment

                Working...
                X