Copy Existing Formula Into New Row

P

pcm1977

I have a spreadsheet that has formulas that are in columns “I” through “O”. These formulas are used to provide information for a pivot table on another sheet. Some of the people that use this spreadsheet are not fluent enough to copy these formulas down to the newly entered row.

What I what to put the formulas in columns “I” through “O” in the first row and hide/lock that row, then when someone enters a new record, code will run and copy the formulas from row 1 down to the current row they are working in.

Example:
I1 = SUM (E1:H1)
J1= AVERAGE (E1:H1)
…etc…

If the user puts data into row 30 then the copy function will run and:
I30 = SUM (E30:H30)
J30 = AVERAGE (E1:H1)
…etc…

Thank you in advance.
 

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

Copy addition formula of non-consecutive horizontal cells 2
Counting Cells With Multiple Criteria on Multiple Sheets 0
Counting Cells With Multiple Criteria on Multiple Sheets 0
reverse pasting rows with alternate blank cells 0
Modify range in VBA 9
Macro to copy formula based on range of other column 2
Average every seven cells, then copy formula 2
Is a Nested Formula what I need? 1

Top