+ Reply to Thread
Results 1 to 3 of 3

help on vba code to Create table of summary from list of data

  1. #1
    Registered User
    Join Date
    10-02-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    4

    help on vba code to Create table of summary from list of data

    First look for latest year in column B till the row end of serial number in column A. Here latest year is 2018-2019. I have to fetch last 3 years details in a seprate sheet product wise as mentioned in sheet "Target"
    Since 2018-19 is the latest year, First copy and sum product-wise all the records of 2018-2019 on sheet Target table format in decending order as per amount.
    then go the last record of the table and move four rows down and again similar way copy records of previous year to 2018-2019. Here previous year is 2017-2018. if there is no previous year then skip to next line
    then go the last record of the table and move four rows down and again similar way copy records of previous year to 2017-2018. Here previous year is 2015-2016. There is no records for 2016-2017. if there is no previous year then skip to next line


    Against all 3 teable I need to copy top-5 records. Here I need an option to change the number of top 5 records (From F to G) number changing option msg box is not required. I will change it from the code directly.. Means if I change the numer in code from 5 to 10 then top 10 records to be copied
    Give Heading as "Top 5 Records" from F-H. If 10 records copied give heading as "Top 10 Records"
    Then give sum in last row as given in row 10

    Then need an code to do fe calclaultions as per the formula given in table on Shete Target

    Also in Column U, I want add remarks as per the given concatenate formula
    In concatenate, as per the number of rows, First highest, second highest, to be given
    In concatenate, in last record instead of 1st, 2nd, mention last row.
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: help on vba code to Create table of summary from list of data

    Looks more like "create a code for me to do this" rather then to help you with your own task. What is your progress so far? Cause there is no code within the workbook
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    10-02-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    4

    Re: help on vba code to Create table of summary from list of data

    Hi,
    I am new to Macro. Hence Dont know how to code it.

    Tried recording macro. But it is not happening.

+ 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] Summary of a particular Code from Data table - outlined per entry
    By mjsmith82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-26-2015, 08:12 PM
  2. [SOLVED] How to Create a Rolling Summary Page that Automatically Updates from a Data Table
    By DontExcelAtMuch in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-28-2013, 03:34 PM
  3. [SOLVED] Create an Summary List from a data set
    By kotonikak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2012, 12:42 PM
  4. How to create summary table from data using VBA
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-22-2011, 02:57 PM
  5. VBA Code to create summary table and Chart
    By KPK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2010, 05:40 AM
  6. Manipulate and arrange table data into summary list
    By DavidSpackman in forum Excel General
    Replies: 2
    Last Post: 07-28-2010, 12:57 AM
  7. lookup? list data into summary table
    By Joe in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-21-2005, 08:30 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