+ Reply to Thread
Results 1 to 4 of 4

How to Manipulate data like a pivot table using a Macro that allow for data to be changed

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Texas, US
    MS-Off Ver
    Excel 2010
    Posts
    5

    Question How to Manipulate data like a pivot table using a Macro that allow for data to be changed

    Practice123.xlsm

    I have a lot to learn about VBA but was looking for advice to help steer me in the right direction with the current project I am working on.

    I have a Intermediate Step Data sheet that has data organized by a Code Number (row) and a Date (column).

    I wrote a sub procedure that loops through all the Code Numbers and sums the values associated with alike Code Numbers on the first date.


    Please Login or Register  to view this content.
    I don't think I can use it for what I am really trying to do though.

    What I need to do is take all the alike code number's values for each date and sum them and store the value in a separate sheet showing the Code Number's Sum associated with that date.

    I think i need to write a procedure similar to the one shown above only utilized a 3D array. I have been reading posts and reading through John Walkenbach's Excel 2010 Power Programming with VBA, and really just feel frustrated to have zero progress in two weeks....

    Any help would be appreciated. Thanks

    Sorry if i didnt explain myself well. I will be happy to try and clear up confusion.
    Last edited by TryingTolearnVBA171; 06-13-2012 at 03:14 AM. Reason: Moderater

  2. #2
    Forum Contributor
    Join Date
    05-25-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Would be really thankful for some help (think i need to use a multidimensional array)

    Hi Trying and welcome to the forums,

    Just a fyi - any code you post needs to be placed in [*code][*/code] (just remove the asterisk) brackets (you can edit your post and add them).

    I'm a bit confused on exactly what you're requesting - I'm sure others (just as myself) would like to view a sample workbook if you have one available? This would definitely help us to determine exactly what you're looking for.

  3. #3
    Registered User
    Join Date
    06-13-2012
    Location
    Texas, US
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Would be really thankful for some help (think i need to use a multidimensional array)

    Thanks, I have one but I am not sure how to post it. How would I do that?

    Thanks Again

  4. #4
    Registered User
    Join Date
    06-13-2012
    Location
    Texas, US
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to Manipulate data like a pivot table using a Macro that allow for data to be chan

    Practice123.xlsm


    Here's a sample of the workbook. I am trying to move the sum numbers associated with dates and account codes in the interm sheet to the proper location in the week(1) sheet.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1