+ Reply to Thread
Results 1 to 6 of 6

Macro for Pivot (a modification in existing vba code)

  1. #1
    Registered User
    Join Date
    05-18-2019
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    29

    Macro for Pivot (a modification in existing vba code)

    Need help, in attached 3 attached file the macro in xlsm file will generate 2 csv output based on other 2 csv file.

    I just need a 2 small modification for the given output.


    1.) The 2 csv output (Hang and Fold) should show "Pivoted Data" it should not show same many container ID in a rows, hence it should be pivoted in same format but there should be no duplication of container in a row. Hence pivot require and the total qty of that container. (In same Format).

    2.)The 2 csv output (Hang and Fold) should show only "Found" remarks containers, please remove those are not found.

    Thank you so much in advance....
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,237

    Re: Macro for Pivot (a modification in existing vba code)

    Administrative Note:

    Welcome to the forum.

    Although we value privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, etc. will suffice).

    Thank you for helping us to help you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-18-2019
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Macro for Pivot (a modification in existing vba code)

    Up.. any luck?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,237

    Re: Macro for Pivot (a modification in existing vba code)

    Administrative Note:

    We don't expect you to bump threads more than once in 24 hours - it has been only a couple of hours since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  5. #5
    Registered User
    Join Date
    05-18-2019
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Macro for Pivot (a modification in existing vba code)

    any chance on this?

  6. #6
    Registered User
    Join Date
    05-18-2019
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Macro for Pivot (a modification in existing vba code)

    help on this

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Minor modification to existing macro (insert data without clearing contents of rows above)
    By marshak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2018, 10:51 PM
  2. VBA Macro Code Modification
    By Suzanrawat12345 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2018, 05:37 AM
  3. [SOLVED] attempted modification of existing macro provides error
    By peter_swe in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-15-2016, 12:50 PM
  4. Modification of a code that Prints all Pivot Filters
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2015, 12:35 PM
  5. [SOLVED] Modification to existing VBA code
    By Jed_c in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2012, 06:35 PM
  6. [SOLVED] modification to existing code to If statement
    By JOUIOUI in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2006, 12:30 PM
  7. [SOLVED] Modification to existing Code
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2006, 12:55 PM

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