atuljadhavne
05-09-2012, 03:56 AM
Dear Expert
I have file having multiple sheets and all sheet having same format
i want to copy particular row from all the sheets which is starting from Row No. 15 to till the data having in A column,
e.g in below table i want to copy entire row from 15 to 18 and copy in single file from every sheet below, after copy this 4 row macro jump to next sheet and copy the row and paste below this row and cont. till last sheet,
in short i want entire row starting from 15 to till data in A column it may be 20 or 100 row or only 2 row
A B .......
15 12345 12
16 23563 25
17 12524 32
18 5252 15
19
20
using excel 2007, file name tool.xls store at E:\May 12\
I have file having multiple sheets and all sheet having same format
i want to copy particular row from all the sheets which is starting from Row No. 15 to till the data having in A column,
e.g in below table i want to copy entire row from 15 to 18 and copy in single file from every sheet below, after copy this 4 row macro jump to next sheet and copy the row and paste below this row and cont. till last sheet,
in short i want entire row starting from 15 to till data in A column it may be 20 or 100 row or only 2 row
A B .......
15 12345 12
16 23563 25
17 12524 32
18 5252 15
19
20
using excel 2007, file name tool.xls store at E:\May 12\