Hi,
Ranges to Copy and Paste as Simple Numbers (Without Formula)
I want such a code which should copy these ranges from sheet1 and then it should open a new sheet (sheet2) and paste this copied data in this sheet 2. The data should be pasted as Simple Numbers only without formulas. These are the Ranges which should be copied from sheet 1
Ranges to Copy and Paste with Same Formulas
This code should also copy these ranges from sheet1 and then it should paste this copied data in this sheet 2. The data should be pasted with the same formulas as they were on sheet 1. These are the Ranges which should be copied from sheet1. For these Ranges Formulas should also remain same as they were on sheet1.
When i again Run this code then it should again copy these ranges from sheet1 and then it should open a new sheet (sheet3) and paste this copied data in this sheet 3. Same way, When i again Run this code then it should again copy these ranges from sheet1 and then it should open a new sheet (sheet4) and paste this copied data in this sheet 4. And so on,
While pasting, cell Format should remain same.
Please note that every cell copied from sheet1 should be pasted in the exactly same cells on sheet 2.
Sample file is attached for more clarification
Bookmarks