Auto delete columns

**JamesT1** · 05-04-2009, 02:13 PM

Hi

I currently use a spreadsheet to record weekly vehicle mileage. I'm looking for a way to automatically delete a column based on a cell value within the column when the vehicle goes off strength

**karan** · 05-04-2009, 02:22 PM

Hi James,

Can you attach a sample workbook to make us understand your problem better?

--Karan--

**JamesT1** · 05-04-2009, 02:53 PM

Hi Karen

The spreadsheet is too large to attach,,,,, the attachment has a small example.....

If the vehicle in cell "G2" is taken off strength and this cell is blank then I am looking for column G to be automatically deleted

Thanks

**JBeaucaire** · 05-04-2009, 03:00 PM

What does "taken off strength" mean to us? And what do you mean by "automatically"? That's a very iffy concept.

Click a button and the columns "automatically" delete if appropriate
Change a value in a cell and the column "automatically deletes (crazy thought, IMO.)

**JBeaucaire** · 05-04-2009, 03:11 PM

Going by the key phrase "if G2 is blank" I wrote a macro that will delete any column that has blank cell in row2 starting at cell C2.

Your sample sheet had formulas, so when I deleted G2 to make it empty and ran the macro, it did what you wanted, but the formulas in the proceeding columns are broken by that process. FYI.

Please Login or Register  to view this content.

The on-demand macro is my suggestion, if it were "automatic"...what if you made a mistake? Oops.

**JamesT1** · 05-04-2009, 03:12 PM

Hi JBeaucaire

"Taken Off Strength" means the vehicle has been sold or disposed off,,,,, when this happens I'm looking to delete the column where the weekly miles are kept,........

**JamesT1** · 05-04-2009, 03:20 PM

Hi JBeaucarie

My Apologies,,,,, in a hurray to put the example together and copied the formulas left to right,,, they should be vertical,,,,

many thanks for the code I will try it on my sheet and let you know how I get on