Answered step by step
Verified Expert Solution
Question
1 Approved Answer
the file Product Sales.xlsx has sales totals for 12 months and 10 different products in the range B4:M13. Write a VBA sub to enter formulas
the file Product Sales.xlsx has sales totals for 12 months and 10 different products in the range B4:M13. Write a VBA sub to enter formulas for the totals in column N and row 14. Use the FormulaR1C1 property to do so. (You should set this property for two ranges: the one in column N and the one in row 14.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started