Hi,
In sheet 1 , i have a list based on number 1 to 9..
I need to add sheets and copy the data to different sheets. The criteria is serial no 1,2,3 etc.
If the sheet doesn't exist, a new sheet must be added.
If it is there, then the data should be copied which does not have any colored row.( yellow color rows are already copied).
Like this all the data should be extracted to different sheets.
The sheet name should be the serial nos 1, 2 etc.
Its urgent, can anyone guide me?
Bookmarks