sheets add and extract data to different from master

[dorabajji]

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?

[Bernie Deitrick]

This will get you going - it deletes existing sheets and copies all the data from the master list, so you will need to modify it to not delete the sheets and not copy colored rows.

Please Login or Register  to view this content.

[dorabajji]

Hi Bernie,
Thank you..
I will check..

[dorabajji]

Hi Bernie,
The non colored cells are also not copied. It returns blank.. As you told it is deleting existing sheet.. but while creating new one.. the numbering is correct, but return blank in data.

[Bernie Deitrick]

Here is a working example - click the button and select a cell in column A.

[dorabajji]

Hi Bernie,
Thanks.. the problem was with filter.. The column i was selecting had formula, but the filter was considering either text or number filter. So the output after was blank.
That was the issue.