I want to use VBA to automatically add a new column "Gross Profit" (Revenue – COGS) and populate it for all rows. How do I insert the column and calculate?
Quarter Product Line Revenue (USD) Cost of Goods Sold (COGS) Operating Expenses Net Income
Q1-2023 Alpha 120,000 70,000 20,000 30,000...
