Thread: Copy Value of Active cell and 25 rows above to a diff worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ash3154 ash3154 is offline
external usenet poster
  
Posts: 23
Default Copy Value of Active cell and 25 rows above to a diff worksheet
Hello,

I am hoping someone can assist me. My spreadsheets consists of 70 columns
and 2000 rows.
If my active cell is bx400, I would like to copy value of bx399 into
spreadsheet "X"'s cell a9. Then take the value of bx398 and copy that into
spreadsheet "X" 's cell ac11, bx397 would be copied to sheet X cell c19 and
so on for the previous 25 rows. (This should only be done when I click on
the macro button)


Reply With QuoteReply With Quote