Update Logic - Clear Contents & Cell Value Formatting

Hello Friends..

Can anyone please assist me in below Point 1 & pont 2..

I tried everything but not getting a correct code to run..

Point 1) Below is the code which helps to clear values from Cells of columns AA, AB & AC if Cells of Column Vis Null or empty

Please Login or Register  to view this content.

The problem here is that i am data of more than 50,000 & the above code takes around 30-45 minutes to execute or sometime crash or sometime no response


Point 2) This below code copies the cell data from column 25 & paste it in column 26 if the cell is blank in column 26.. but after copying it is converting the date as date (
attached is the file for reference..
The data in Column Z cells marked in yellow shows data as year 2017.. but according to Column V its 2016 year.. example (RUM122316-070725-49)
How can we change or update the code .. please suggest

Please Login or Register  to view this content.

Hello Experts please suggest/ assist a better code for Poiint1 & Point 2

Hello Parth007,

The code shown for Point 1 is 3 times faster on the sample workbook and will be much faster on a larger data set.

As for Point 2, the abbreviated date method displaying the the month and day less the year, mm/dd, only works with the current year. You cannot use this format with dates that are not the current year. You will have to display the date in mm/dd/yy format.

Point 1 Macro Code

Please Login or Register  to view this content.

Hello Parth007,

The code shown for Point 1 is 3 times faster on the sample workbook and will be much faster on a larger data set.

As for Point 2, the abbreviated date method displaying the the month and day less the year, mm/dd, only works with the current year. You cannot use this format with dates that are not the current year. You will have to display the date in mm/dd/yy format.

Point 1 Macro Code

Please Login or Register  to view this content.

hi Ross,

The Code for Point 1 WORKED... I HAVE CHANGED THE '<' & '>' to '='

Please Login or Register  to view this content.

Please assist me if the changes I have done is correct