faddak
11-29-2023, 12:48 PM
Hi
I'm working on a project in Excel where I need to automate the formatting and summarization of sales data using a macro. The data includes columns for Date, Product, Quantity, and Amount. Could someone guide me on how to create a macro that accomplishes the following tasks:
Format the Date column in the "dd-mmm-yyyy" format.
Calculate the total sales amount for each product and display the result in a new summary table.
Highlight products with sales amounts above a certain threshold (e.g., $500) in the summary table.
Generate a report with formatted dates, total sales, and highlighted products in a new worksheet.
I would appreciate any insights, tips, or sample code that could help me achieve this automation.
Thank you in advance for your assistance!
I'm working on a project in Excel where I need to automate the formatting and summarization of sales data using a macro. The data includes columns for Date, Product, Quantity, and Amount. Could someone guide me on how to create a macro that accomplishes the following tasks:
Format the Date column in the "dd-mmm-yyyy" format.
Calculate the total sales amount for each product and display the result in a new summary table.
Highlight products with sales amounts above a certain threshold (e.g., $500) in the summary table.
Generate a report with formatted dates, total sales, and highlighted products in a new worksheet.
I would appreciate any insights, tips, or sample code that could help me achieve this automation.
Thank you in advance for your assistance!