View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anders[_2_] Anders[_2_] is offline
external usenet poster
 
Posts: 8
Default Macro: Copy data to another sheet

Hi,

I have a rather simple question, I think.

I have a matrix of numbers (M38:O49) on sheet1. I need to have a macro
that copies these numbers from sheet1 to sheet2.

On sheet2 the numbers should not just be copied into a new matrix
(AB3:AD12), but added to the numbers already located in the sheet2 matrix.


So if my matrix on sheet1 consists of only 1's and the matrix on sheet2
consists of 4's, then the matrix on sheet2 should read only 5's after
applying the macro. Now filling sheet1 with only 4's should then produce
a matrix on sheet2 with only 9's after applying the macro once more, etc.


How can I do this (is has to be a macro!)?

Anders