• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

copy/paste alternate cells

pao13

pao13

Member
Hi. I attached my spreadsheet.

I have some values in column E and I want E4=E5, E6=E7, E8=E9, etc. Can I do that with a macro?
 

Attachments

  • RSX DATA25.xlsm
    140.6 KB · Views: 0
Pao,

Would it work to paste the following formula in E4 and drag down?

=IF(MOD(ROW(),2)=0,ROUND(C4*2,0)/2,E3)
 

Attachments

  • pao1.xlsm
    136.6 KB · Views: 0
In E4: =E5
Select E4 Copy (Ctrl+C)
Now Select E6
Holding the Ctrl Key select E8, E10, E12 ... etc
Paste (Ctrl+V)
 
This works great! Thanks again eibi!

Thank you for your answer Hui but I prefer eibi's way!
 
You must log in or register to reply here.
Back
Top