+ Reply to Thread
Results 1 to 6 of 6

Need assistance on vba macro for Yearly Flash report

  1. #1
    Registered User
    Join Date
    01-10-2023
    Location
    Kolkata
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5

    Post Need assistance on vba macro for Yearly Flash report

    Hi,

    I need a vba macro, which will automate the manual work. The sample file attached, consist of Master Data, which contains the raw data, which keep on adding every week.

    First step - In Sheet "Table", we have a pivot table. Segregation is done based on sub category, beside the table there is 4 sub heading as NA,EU,FE and SA, where NA marketplace is 1, EU marketplace is 2, FE marketplace is 3 and SA marketplace is 5. The calculation should be done like, NA whose marketplace is 1 for the respective sub category, would check in pivot table for 1 for the same sub category, then it should check the count value of marketplace and divide it by total of that sub category. Eg- NA whose marketplace is 1, with count value as 63 and total as 322,so Calculation : "=Count of Marketplace value of 1/Total of the Count Value of that sub category". This should be done for all 4 marketplace and for all category. As present in the Table sheet.

    Second Step - This Calculation should be added among the 3 sheet, i.e., Hardline, Softline and Consumables. This 3 sheet have the sub category. So Value should be added to the respective sheets based on the sub category. Placement of value should be exact for the sub category. Eg - Accessories NA value should be added to the Softline sheet Accessories NA. Raw data consist of only weekly data. We need to calculate monthly basis also, i.e, summation of 4 week data for 1 month. We need to calculate quarterly basis also, i.e., summation of 4 month.

    Third Step - Value from this 3 sheet, should be added to the Final_Data vertically based on the headings given.

    Thanks in advance for looking into the query.

    PTD Automation.xlsx


    Thanks and Regards,
    Aswini Dubey
    Last edited by Aswini Dubey; 01-16-2023 at 05:41 AM. Reason: Attached File

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Need assistance on vba macro for Yearly Flash report

    No sample file attached!
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    01-10-2023
    Location
    Kolkata
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5

    Re: Need assistance on vba macro for Yearly Flash report

    Hey JohnTopley,
    Was trying the same to attach the file as it was too big. trying to reduce it and upload that.
    Just give me some time to upload it.

  4. #4
    Registered User
    Join Date
    01-10-2023
    Location
    Kolkata
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5

    Re: Need assistance on vba macro for Yearly Flash report

    Attached the file above..
    Please review and provide the resolution accordingly.

  5. #5
    Registered User
    Join Date
    01-10-2023
    Location
    Kolkata
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5

    Re: Need assistance on vba macro for Yearly Flash report

    Hi,
    Any update on the above case.

  6. #6
    Registered User
    Join Date
    01-10-2023
    Location
    Kolkata
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5
    Quote Originally Posted by Aswini Dubey View Post
    Hey JohnTopley,
    Was trying the same to attach the file as it was too big. trying to reduce it and upload that.
    Just give me some time to upload it.
    Any update, is the above automation possible?

+ 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. Automating Simple Report - VBA Assistance requested
    By Lee_of_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2021, 06:40 PM
  2. [SOLVED] Generate a report where there are yearly cap on reimbursement for employees
    By just4usam in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-13-2021, 11:07 AM
  3. Replies: 3
    Last Post: 12-16-2014, 07:05 PM
  4. Abstracting a monthly report into yearly report
    By Deepa Shrestha in forum Excel General
    Replies: 1
    Last Post: 07-25-2013, 07:09 AM
  5. Replies: 0
    Last Post: 02-09-2011, 02:47 PM
  6. monthly report with yearly results view
    By dsmelz in forum Excel General
    Replies: 0
    Last Post: 12-04-2008, 12:07 PM
  7. Yearly report - needs two Y-axis
    By tonynz in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-18-2005, 09:48 PM

Tags for this Thread

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