-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
update formulas
-
T
Update formulas on multiple worksheets feeding from another
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...- TenCO
- Thread
- cell references invoices update formulas
- Replies: 1
- Forum: Excel Questions
-
Copy sheet into diff. workbooks, update formulas for new workbooks?
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: [---------...- Gingertrees
- Thread
- copy sheet update formulas
- Replies: 1
- Forum: Excel Questions
-
S
Update multiple formulas with VBA
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...- svjensen
- Thread
- update formulas
- Replies: 2
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
