KentKHI
Active Member
- Joined
- Oct 1, 2004
- Messages
- 492
How can I use code to apply a simple formula to a range of cells that will make them equal to cells on another sheet?
example
sheet2 A1 should equal sheet1 A1
sheet2 A2 should equal sheet1 A2
This continues for about 45 cells, so I would like to identify the sheet to copy from, and paste a formula in each cell, rather than rewrite a formula for each cell.
Thanks!
example
sheet2 A1 should equal sheet1 A1
sheet2 A2 should equal sheet1 A2
This continues for about 45 cells, so I would like to identify the sheet to copy from, and paste a formula in each cell, rather than rewrite a formula for each cell.
Thanks!