Copy/Paste Help Please

D

Den

When trying to do a copy/paste of the first three line I get what is
showned; but I would like to the progression to go on with: 31, 37, 43
and so on for the next 30 lines or more.

=Sheet1!$E13*DAY($A13)+Sheet1!$E14*Sheet2!$D$5-DAY($A13) original
=Sheet1!$E19*DAY($A19)+Sheet1!$E20*Sheet2!$D$5-DAY($A19) ..
=Sheet1!$E25*DAY($A25)+Sheet1!$E26*Sheet2!$D$5-DAY($A25) ..
*no blank line here*
=Sheet1!$E16*DAY($A16)+Sheet1!$E17*Sheet2!$D$5-DAY($A16) copy
=Sheet1!$E22*DAY($A22)+Sheet1!$E23*Sheet2!$D$5-DAY($A22) ..
=Sheet1!$E28*DAY($A28)+Sheet1!$E29*Sheet2!$D$5-DAY($A28) ..
=Sheet1!$E19*DAY($A19)+Sheet1!$E20*Sheet2!$D$5-DAY($A19) ..
=Sheet1!$E25*DAY($A25)+Sheet1!$E26*Sheet2!$D$5-DAY($A25) ..
=Sheet1!$E31*DAY($A31)+Sheet1!$E32*Sheet2!$D$5-DAY($A31) ..
=Sheet1!$E22*DAY($A22)+Sheet1!$E23*Sheet2!$D$5-DAY($A22) ..


What I am doing wrong or what chapter of excel should I look for?

Den
 

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 Problem (progression in formulas) 0
Formula 6
Block copy/insert of 5 rows, then update formula below? 2
copy cell to next open line 1
Combine Formulas 5
Tricky Formula 2
Tricky Formulas 14
Copy nonadjacent Autofiltered cells to another sheet 0

Top