troubleshooting Question

Create a macro to copy formula based on certain criteria

Avatar of xllvr
xllvrFlag for United States of America asked on
Microsoft ExcelVB Script
17 Comments1 Solution210 ViewsLast Modified:
Hello Experts,

I have mocked up some data as an example of what I'm trying to achieve.  Sadly, the data is not how I would structure it, but my hands are tied.  This data is ripe for a pivot table.  Not sure how I could clean up the data to provide a contiguous block of information to pivot off of without creating a new column for an account number.

The person I am doing this for showed me the structure I have provided here in the attached file.  I want to create a macro (Do While or Until?) that copies the formulas down but also totals by Account (the shaded rows).  Hopefully, this will be clearer when you see the mock up.

If I could assign more points, I would! Totals-macro.xlsx
Join our community to see this answer!
Unlock 1 Answer and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros