update formulas

I have a file that lists the months in columns and several vendors as rows. Each month I put in their sales figures, which then is used to calculate fees we charge them in a couple rows below. For each vendor, I have a separate worksheet that has an invoice template that pulls the fee over...

In a moment of poor planning, I published a workbook (set up like a form, for people to fill out) without having a page for me that compiles all the fields nicely for easy collation. So the form includes on sheet1: Name: [--------------------]...Date: [------------] Address: [---------...

I need to update the formulas in a number of cells (range("C12:G14")) using VBA. The formula is fairly simple, as it is just a reference to an other cell times a given value (along the lines of '=C5*Sheet2!A$1$'). I have tried doing this with the following script, but the column reference is...