Macro that will insert formulas in the last row of different works

S

ScottMSP

Hello,

I need a macro that will insert two formulas below the last row of column AB
in every worksheet I have in a workbook. The number of rows in each
worksheet varies so I never know what the last row is. In addition, I need
to include headers to the left of each cell that contains the formula.

The two formulas that I need to insert average data based on conditions in
two other columns. The two formulas are:

Average Increase {=AVERAGE(IF(([RANGE IN COLUMN N]>0)*([RANGE IN COLUMN
P]<>110), [RANGE IN COLUMN AB]))}

Casual Average Increase {=AVERAGE(IF(([RANGE IN COLUMN N]=0)*([RANGE IN
COLUMN P]<>110), [RANGE IN COLUMN AB]))}

Thanks in advance for your help.

-Scott
 

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

Macro that will Insert Formulas in last row of different worksheet 0
Macro to insert formulas in the last row of different worksheets 1
Macro to insert formulas on last row of different worksheets 1
Insert Row also adds formulas and moves cursor 2
Need Help with a VBA subroutine 0
Setting column width in a table with a macro is not working 0
End process at last row of data 3
Keeping formulas on an insert 1

Top