search date value and then delete cell then shift up

[k1dr0ck]

hi,

i have dates in A4 to CV153 they are formatted as ddd-mmm-dd
example:
A4=06/19/16 format/shown as "Sun-Jun-19"

how do i search the word "Sun" then if found delete the cell and shift up
(shift the cell up in the column not the entire row)

i have the initial code below

Please Login or Register  to view this content.

[NeedForExcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[k1dr0ck]

hi,

attached sample file

the bold format are just to easily discern dates with sunday for the sample file in sheet 1
the output is in sheet 2

[bulina2k]

Hello friends!
Hope it's ok to jump in.
I used the following code:

Please Login or Register  to view this content.

[NeedForExcel]

Try this

Please Login or Register  to view this content.

[k1dr0ck]

hi,

thanks guys, both code works great!