VBA to copy a formula down a range based on the size of the pivot table parallel to it

**The_Snook** · 07-24-2013, 04:21 AM

Morning all,

What VBA code do I require to copy the formulas in cells D4 and E4 down to match the same row as the last date in the pivot table running adjacent to it, i.e. down to row 116? The pivot table will regularly change size so ideally I need something to recognise the size of the pivot table and copy down accordingly.

Example attached.

Thanks in advance,

Snook

**nilem** · 07-24-2013, 04:44 AM

Hi The_Snook,
try something like

Please Login or Register  to view this content.

**The_Snook** · 07-24-2013, 05:20 AM

Works a treat mate, cheers!

If you don't mind could you write a brief explanation of how it works to increase my understanding?

Thanks

**nilem** · 07-24-2013, 09:30 AM

Please Login or Register  to view this content.

**The_Snook** · 07-24-2013, 10:35 AM

Superb, that's been a big help, thanks!

VBA to copy a formula down a range based on the size of the pivot table parallel to it

LinkBack

Thread Tools

Rate This Thread

Display

VBA to copy a formula down a range based on the size of the pivot table parallel to it

Re: VBA to copy a formula down a range based on the size of the pivot table parallel to it

Re: VBA to copy a formula down a range based on the size of the pivot table parallel to it

Re: VBA to copy a formula down a range based on the size of the pivot table parallel to it

Re: VBA to copy a formula down a range based on the size of the pivot table parallel to it

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dynamically Changing Position of Pivot Based on Size of Another Pivot Table

Excel 2007 : Pivot table top 5 filter,pivot table size and range

Create a table with size based on a formula (VBA)

Automatically selecting print area based on Pivot Table size

Auto size a pivot table to a page size

Bookmarks

Bookmarks

Posting Permissions