Hi All,
I am trying to copy cells in a range (sheet1) that are greater than zero, and paste to another worksheet (sheet2) in a defined cell. Currently the code I am using works, but it doesn't have the flexibility of choosing a defined range to copy from, and a defined cell to paste the values to.
The copied range is starts in sheet 1, cell A1. The copied range pastes to Sheet2, cell A2 (by default). Wondering if there is a VBA wiz out there than can explain how to control where you copy and paste your ranges to between worksheets?
Am new to this community and grateful for the responses I have had to my problems so far! Thanks in advance
Here is my code:
Please Login or Register to view this content.
Bookmarks