Hi,
First, let me say thank you to L.Howard for giving me advice on how to properly present my excel problem.
I really need your advice, or better to say, help.
I need to copy data from one sheet to another, but the trick is that the arrangement of cells is different in each sheet.
To be more precise, I need the value in cell A4 in sheet 2 to be in cell A1 in sheet 1, cell A15 in sheet 2 to be in cell A2 in sheet 1, cell A26 in sheet 2 to be in cell A3 in sheet 1 and so on. So basically, the difference is always 11. Since I’m dealing with a ton of data, I need formula for this.
Thanks a lot.
First, let me say thank you to L.Howard for giving me advice on how to properly present my excel problem.
I really need your advice, or better to say, help.
I need to copy data from one sheet to another, but the trick is that the arrangement of cells is different in each sheet.
To be more precise, I need the value in cell A4 in sheet 2 to be in cell A1 in sheet 1, cell A15 in sheet 2 to be in cell A2 in sheet 1, cell A26 in sheet 2 to be in cell A3 in sheet 1 and so on. So basically, the difference is always 11. Since I’m dealing with a ton of data, I need formula for this.
Thanks a lot.