I don't understand the details.

Maybe it's time to rewrite the requirements.

And post a small example (as text in the message) of the data before and what it
should look like after.



wrote:

thanx Mr adve for ur reply

But My prblem is bit complex

i want to check value frm the adjacent column
i mean say i have data in colA and colB

so i want to check if there is empty cell in colA and also in colB at
same row then its fine(say 5th row is empty for both columns)then no
need to fil data there

but for example if columnA [7th row] is non-emty and columnB [7th row]
is emty then i want to apply the macro u suggested likewise check for
values in other rows too

http://contextures.com/xlDataEntry02.html

--

Dave Peterson