VBA Code for Adding % Diff Column to Numerous Sheets?

**kestefon** · 02-20-2013, 04:18 PM

Hi,

I have a huge Excel document with 1000+ sheets. Each sheet has "year" columns (2009, 2010, 2011, and 2012), and varying numbers of rows (anywhere from 1 to about 100), and I'd like to add columns to each sheet showing the year vs. year % difference.

I've attached a workbook with a before/after example. Any help on this would be greatly appreciated.

Thanks

Excel Percent Diff Example.xlsx

**xladept** · 02-20-2013, 04:25 PM

Are the % columns already there? Or must they be inserted?

**kestefon** · 02-20-2013, 04:36 PM

The columns are already there (I just added an attachment to my original message, by the way). Basically I'll have all of the sheets formatted, and I'll just be adding three % difference columns to each one. I could just select all the sheets and drag the forumula down, but that doesn't work since each sheet has different numbers of rows. Of course, if I were just dealing with a handful of sheets, this wouldn't be a problem, but since I have more than 1000 sheets to format, I need to figure out a simple way of doing this.

**kestefon** · 02-20-2013, 05:31 PM

Are you able to access the attachment?

**watersev** · 02-20-2013, 06:08 PM

hi kestefon, option, formulas and % format get inserted, run code "test1"

**xladept** · 02-20-2013, 06:34 PM

In that case - try this:

Please Login or Register  to view this content.

**kestefon** · 02-20-2013, 09:24 PM

Thanks, guys, those work perfectly! I was even able to figure out how to adjust watersev's to do add a % share column.

Thanks again.

**xladept** · 02-20-2013, 11:18 PM

You're welcome!

**kestefon** · 02-20-2013, 11:47 PM

One more question pertaining to this project: Is there a way to automatically rank all of the sheets in my report? I would basically like to re-sort all of the rows so that the data is high-to-low on the 2012 column.

**watersev** · 02-21-2013, 05:44 AM

@kestefon

Please Login or Register  to view this content.

**xladept** · 02-21-2013, 01:50 PM

Hi Kestefon,

Here's mine:

Please Login or Register  to view this content.

VBA Code for Adding % Diff Column to Numerous Sheets?

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Re: VBA Code for Adding % Diff Column to Numerous Sheets?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions