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.