Automatically Adjusting a Column with a Formula

[mellissacook]

I am looking for a way to make a formula column automatically adjust to the numbers in the cell, without having to adjust it myself.
Column B: W/H SUMMARY
Column C: TAX PC
Column D: Formula: =SUM(B3-C3)
*Please see attached document for a look at my excel file*

Before I entered the 1,000,000 in Column B, col. D showed 0.00. When I enter a number into col. B or col. C I want col. D to adjust to fit. For example, right now it sould show 1,000,000. BUT, when I enter 1,000,000 into col. C I want col. D to go back to the smaller size.
Thanks!

[Portuga]

You can add the following code to your sheet:

Please Login or Register  to view this content.

Right click on the sheet name and select "see code" and paste it there.
You will need to have this code in every sheet you wish automatic column/row ajustment

[mellissacook]

Worked perfect! Thanks!!

You can add the following code to your sheet:

Please Login or Register  to view this content.

Right click on the sheet name and select "see code" and paste it there.
You will need to have this code in every sheet you wish automatic column/row ajustment

[mellissacook]

Ok. now there was a problem. It worked great until I protected the sheet. The only columns that people can enter data into are b & c. So, when I protect it run-time error 1004 pops up and when I click "debug" to see the problem, it highlights ".Rows.AutoFit"

Any ideas?
Thanks again!

You can add the following code to your sheet:

Please Login or Register  to view this content.

Right click on the sheet name and select "see code" and paste it there.
You will need to have this code in every sheet you wish automatic column/row ajustment

[mellissacook]

bump .

[Portuga]

try

Please Login or Register  to view this content.

Changing correspondingly the columns you want.

First you should select the columns B and C and uncheck "Blocked" in "format" "cells"

You can now protect your sheet (You must allow for Column format in your protection)