troubleshooting Question

Copying range of cell formulas down a range of cells

Avatar of deskchains
deskchainsFlag for United States of America asked on
Microsoft Excel
4 Comments1 Solution286 ViewsLast Modified:
Not enough time and/or personal knowledge to piece this one together from all the other questions surrounding this copy past topic....I see it in there but cant put my finger on it.

I have a macro that places formulas in a row of cells.  Lets say the formulas are in cells N8:Z8.  I want to copy these cells/formulas down N number of times based on where values in cell F8 down to F##  are populated/turn null.  So if their are values in cell F8 to F20 the formulas in N8:Z8 would be copied from N9:Z20 - if there are values all the way down to F2356 the formula would be copied to cell N9:Z2356 - so on so forth.

By the way.  I have this working via placing the data into a "table", so that the formula gets automatically populated downward the correct number of times; however I need to get away from having the data stored in a table - whole other issue...
ASKER CERTIFIED SOLUTION
Saqib Husain
Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 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 4 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