Hi all,
I want to make some archive macro in sheet 1, and i dont know how to do that.
In sheet 1 i am calculating something in random cells (example cell B1, B3, and B5). In Sheet 2 I want to make an archive in which i want to store values from sheet 1 in this order - B1 goes to A4, C3 goes to B4, D5 goes to C4. The coping procedure must be only values not formulas. Then If I calculate something else in sheet 1 and start macro again, new values from B1, B3 and B5 must be stored in cells A5, B5, and C5 in sheet 2. Each next click on the macro, values from sheet 1 would be copied in the first next new free row below the last data in sheet 2 in columns A, B and C
Can someone please help me on this
I want to make some archive macro in sheet 1, and i dont know how to do that.
In sheet 1 i am calculating something in random cells (example cell B1, B3, and B5). In Sheet 2 I want to make an archive in which i want to store values from sheet 1 in this order - B1 goes to A4, C3 goes to B4, D5 goes to C4. The coping procedure must be only values not formulas. Then If I calculate something else in sheet 1 and start macro again, new values from B1, B3 and B5 must be stored in cells A5, B5, and C5 in sheet 2. Each next click on the macro, values from sheet 1 would be copied in the first next new free row below the last data in sheet 2 in columns A, B and C
Can someone please help me on this