Hi,

I'm not a VB.Net programmer by trade but I have used it in the past for some small projects.

I need to be able to take an Excel spreadsheet and delete all the rows that have nothing on them, or don't contain a number on all the columns i'm interested in.
So basically cleaning up a dump from another program.

Then I need to copy all that information into a new worksheet in an existing Excel workbook.

Then I need to insert a column in an existing worksheet (same workbook) and use a pre-determined set of formula but substitute values in from the new worksheet.

Can this be done using Visual Basic .Net, do I need to buy any extensions, or add-ins? or can you give me some advice on what language I should use.

Thanks,
:Ant

PS: Here is a basic example of what I want to do.

Output from other Accounting package in Excel Format.
Code:
(output.xls->main worksheet)
12.95 X1123 C 2005-10-10
12 
#
12.95 F0023 D 2005-10-15
This would become
(output.xls->new worksheet)
Code:
12.95 X1123 C 2005-10-10
12.95 F0023 D 2005-10-15
Now we copy that worksheet to the existing workbook so we have it called:
(existing.xls->Oct 2005)
Code:
12.95 X1123 C 2005-10-10
12.95 F0023 D 2005-10-15
And the existing worksheet that holds the summary for all months needs a new column for the October transactions.. so we need to copy the formula used for September but instead of referencing the Sep 2005 worksheet we will need to reference the Oct 2005 worksheet.

If this is do-able, please let me know.. I would like to get started this week.

Thanks,
:Ant