Auto-update column formula

A

Alex

I have a simple formula as follows
A B C
1 100 200
2
3 4 5 (4*100)+(5*200)

I have a macro that can insert any number of desired columns but i need the
formula in column C to update and include the new inserted columns. I would
then need to paste this all the way down column C (but only in certain cells).
 
L

Luke M

Why not use the formula:
=SUMPRODUCT(A$1:B$1,A2:B2)

Then, if you insert columns between A and B, the formula will automatically
expand?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Consolidation Table from Different Excel Tabs with Different Format 1
Copy addition formula of non-consecutive horizontal cells 2
Two columns followed by single page-width column on same page 0
Number range as a percentage 2
Vlookup or similar 7
Having Blank Cells, etc. ? 1
averaging data in multiple columns 6

Top