+ Reply to Thread
Results 1 to 5 of 5

Help in preparing order summary

  1. #1
    Registered User
    Join Date
    08-17-2021
    Location
    Chennai, India
    MS-Off Ver
    Excel for Mac 16.52
    Posts
    4

    Help in preparing order summary

    HI,

    I am in need of a macro to perform the following task. I have attached a system generated CSV file (Changed file format to excel). Now I need to prepare a summary sheet based from the base data. The sample summary sheet is also attached. No of rows will change from day to day. Sometimes it can be even 5000 rows.

    Column AE to AL has the items sold as text. We need to extract this and put it in summary

    For eg. lets take AE3 as example. Chicken Shawarma_NA_1_136 means Chicken Shawarma 1 quantity and amount 136. Similarly AF3 Mexican Shawarma Plate_NA_1_189 is Mexican Shawarma Plate 1 quantity and amount 189. This goes on till the last item in the bill. if there are 10 different items in the bill, then 10 different columns are created i.e from AE to AN.
    Attached Files Attached Files
    Last edited by mohan3081; 08-17-2021 at 08:06 AM.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: Help in preparing order summary

    Welcome to the forum. Here is a solution using Power Query, with the following M Code:

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-17-2021
    Location
    Chennai, India
    MS-Off Ver
    Excel for Mac 16.52
    Posts
    4

    Re: Help in preparing order summary

    Thanks for helping out. Sry for the layman question. How to run this query. I am used to macro actually.

  4. #4
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: Help in preparing order summary

    I am not sure about Excel for Mac, but for me > Data > Show Queries > right-click query > Edit.

  5. #5
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: Help in preparing order summary

    You don't run the query.. you right click on the table and select Refresh whenever new data are added.

+ 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. Macro to identify contra entries and then preparing summary for same
    By caavimak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2012, 01:04 AM
  2. Need help in preparing Summary report through excel vba
    By compumast in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-05-2012, 03:42 AM
  3. Replies: 3
    Last Post: 11-08-2011, 02:43 AM
  4. Order form - Summary page
    By Danwin in forum Excel General
    Replies: 4
    Last Post: 12-09-2009, 02:52 PM
  5. Order summary
    By njg2982 in forum Excel General
    Replies: 14
    Last Post: 11-02-2009, 01:26 PM
  6. Trying to provide a order summary.
    By Steve-B in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-21-2009, 08:39 AM
  7. Order Summary Page
    By odie2828 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-03-2008, 04:39 AM

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