omar23j
10-02-2018, 11:36 AM
Hi,
I have multiple tabs ( A,B,C,D,E,F AND G) in an excel file that contain multiple rows ( from row 2 until indefinite). Each of these rows contain information in columns A to Y.
I want to paste each of these rows inside a new tab ''New'' in the positions ( row 2 until indefinite). Once that is done I need the rows to be sorted by ascending order based on the index number contained in Column A.
I attempted solving this by doing a copy paste operation from the original tabs to the new one. But that would not take into account how many rows there is in a specific tab. I need to set a condition where I am copying rows until the following row is empty.
If I am not clear enough or not providing enough information please let me know.
Any help is appreciated,
Thanks!
I have multiple tabs ( A,B,C,D,E,F AND G) in an excel file that contain multiple rows ( from row 2 until indefinite). Each of these rows contain information in columns A to Y.
I want to paste each of these rows inside a new tab ''New'' in the positions ( row 2 until indefinite). Once that is done I need the rows to be sorted by ascending order based on the index number contained in Column A.
I attempted solving this by doing a copy paste operation from the original tabs to the new one. But that would not take into account how many rows there is in a specific tab. I need to set a condition where I am copying rows until the following row is empty.
If I am not clear enough or not providing enough information please let me know.
Any help is appreciated,
Thanks!