snoopies
06-15-2005, 10:48 PM
Dear all,
I wanna copy all worksheets within the workbook to new ones...
But I want to skip all rows with a value "X" or empty cell in Column A..before
copying to new sheets..
The name of new sheets will be the header in col A.
For example, in sheet 1, A1 is May, then a new sheet "May" is created copying all rows in sheet1 (without empty cell/X) in col A..
For example, in sheet 2, A1 is June, then a new sheet "June" is created copying all rows in sheet2 (without empty cell/X) in col A..
Can anyone give me clue?
Thank you. :help
I wanna copy all worksheets within the workbook to new ones...
But I want to skip all rows with a value "X" or empty cell in Column A..before
copying to new sheets..
The name of new sheets will be the header in col A.
For example, in sheet 1, A1 is May, then a new sheet "May" is created copying all rows in sheet1 (without empty cell/X) in col A..
For example, in sheet 2, A1 is June, then a new sheet "June" is created copying all rows in sheet2 (without empty cell/X) in col A..
Can anyone give me clue?
Thank you. :help