I have a Pivot Table that spans from Column A to D. My code inserts formulas in F3:F5. I want to copy these formulas to rows 7 to 9 and 11 to 13. As I add more months, I want to copy the formulas down. I have attached a sample file which will highlight my problem.
Thank You in advance
Last edited by Aland2929; 07-23-2010 at 03:34 AM.
I have tried to use the offset function and a Loop routine but can't figure this out?
You could add the line
Then change your autofill range to F3:F6 instead of F3:F5
Please Login or Register to view this content.
Thank you Huron.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks