VB + Excell

I'll admit im pretty much a VB noob so I may be asking a stupid question. My problem is I need to alter an existing Excell sheet quick and easy as it needs to be done weekly.

I want to record a macro in excel to do it however, I dont know how to write the VB to do a portion of the required steps.

The meat of my problem is this...
I need to indentify if certain columns have information, in the form of a date, located in them. If they do, I need to remove the information from said column as well as remove a monetary value from a different column. I also need to subtract that monetary value from the total at the end. BTW, this is for many, many rows of data. If it were only a few rows I wouldn't worry with trying to build a macro or a faster way to handle the change.

Other steps I need to take is simple, remove a whole column and recalculate the total after any deletion.

I was considering using an If/Then but as far as VB is concerned I honestly dont know where to start. Any advice would be greatly appreciated.

Will

You can use VBA code within excel, look at the online help

Or you can use some other program like one in VB6 that can manipulate excel from within the VB6 code by creating an instance of excel. You might look around www.mvps.org for sample code.

The way to start:

Use the Exel's tools - macro - Record Macro, facility
All you do is recorded to a macro (it's the easest way to learn and to make some programs), I allways do it and junk some parts of it to do in a more general way.

If a more specific question, just post it.