Run Code if Adjacent Cell is not empty

[bhenlee]

Hi Experts,

I have this code to sort column A:

Please Login or Register  to view this content.

need an IF statement so that the the code will run if the adjacent cell in column c is not empty.

Like if i enter a name in A38 - it will only sort as soon as i'm done entering the data in C38..

thank you.

[YasserKhalil]

Hello
Can you attach sample of your workbook? Does your code in worksheet_change event?

[bhenlee]

Yes it is the worksheet_change event..

The sort will kick in as soon as a Name is entered in Column A..

Is there a way to postpone it or have it run after data is entered in the adjacent cell in column C?

Say the name to be added to the sort is entered in A4 - it shouldn't be sorted until data is entered in C4..

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[bhenlee]

Hi YasserKhalil,

Thank you for the code.. it works with the Sample file but i'm not sure why it won't work with my actual data...

i'm just changing the range to the actual named range in my sheet.

Any idea?

[YasserKhalil]

It is better to attach sample of your original file
I think you have to put the code then save the file .. then close and open again
Do you encounter any errors?

[bhenlee]

it works fine on my other sheet but im not sure why it won't work on the other file..

question: could you modify the code so that when a previous data is deleted the sort will still work...

say the data in row 2 is deleted.. need the remaining data to sort and occupy any empty spaces

[YasserKhalil]

Can you attach a sample that is similar to your original file?

[bhenlee]

i was able to make it work YasserKhalil.. thanks..

to my question - could you modify the code so that if a previous data is deleted the sort will still run and rid out any empty rows

[YasserKhalil]

Can you explain more the second point ..?
What cells would you clear the contents .. In what column?

[bhenlee]

in the same sheet..

say if i delete the data in A3:C3... need the the data below it to move up...

basically there shouldn't be any empty rows within the table

[YasserKhalil]

Try this version

Please Login or Register  to view this content.

[bhenlee]

thank you, Yasserkhalil

[YasserKhalil]

You're welcome. Glad I can offer some help
Please mark the thread as solved