Need IF statement

[rwilley]

I have an Excel worksheet with about 1000 records. Some of the cells have information that needs to be deleted and a cell needs to be added to others. This only happens in a few of the columns 4 out of 35. How can I write a macro to remove the unwanted info and also add cells.

Example - row 3, column O needs to have a cell added - row 9, column M needs to have information removed from the cell or delete that cell and add another in its place.

I believe if I can get these two working I can use the same info to fix the others since they are in the same columns different rows.

Thanks,
Ralph

[Simon Lloyd]

It would help if you explained where and what data is to be removed and where and what cells are to be added as well as the criteria for this event.

Regards,
Simon

[rwilley]

Example - row 3, column O needs to have a cell added - row 9, column M needs to have information removed from the cell or delete that cell and add another in its place.

I believe if I can get these two working I can use the same info to fix the others since they are in the same columns different rows.

Thanks,
Ralph