delete data

[mathanraj76]

Hi..
I have Data from column A to Column Au
What i want is when those column Data From"D to AA" is empty then i want these entire rows put into new sheets.."From A to AU"
If column D,E,F is empty and Column G,H,I, have data then this rows put into new sheets with header..
Can u help me to solved for me..


Thanks

[djbomaha]

Hi mathanraj,

Here is some code that does what you described. I have attached the worksheet with an example of it working. If you hit "<CTRL> d", it will run the macro that distributes the data. Hit "<CTRL> r" to reset the sheet.

Please Login or Register  to view this content.

Thanks,

Daniel

[mathanraj76]

Thanks .
U solved my problems .