VBA Code Help

[stacey52891]

I need help writing VBA Code that will work for a spreadsheet I am working on. I have tried the record macro process but I cannot get a date column I am working with the format correctly. This data is coming from a program and needs to be scrubbed so formulas can be written for it.

In column A: I have statuses. I need any lines of data that have a status of "DENI" or "PEND".

In column B: I need these cells to be formatted to: MM/DD/YYYY

I need this to be done on multiple sheets, could you show me how this could be nested together so that these actions are done on "Sheet1", "Sheet2", and "Sheet3". However, this does not need to be done to ALL sheets. Thank you so much for your help with this.

App Status	last_update_time
COMPL	2017-Jan-04 10:03:14
COMPL	2017-Jan-05 16:49:47
COMPLETED	2017-Jan-04 16:59:50
COMPLETED	2017-Jan-05 12:28:00
DENI	2017-Jan-05 00:15:16
DENI	2017-Jan-05 00:15:16
N/A	2017-Jan-04 10:47:45
N/A	2017-Jan-05 16:08:31
PEND	2017-Jan-05 16:49:47
PEND	2017-Jan-04 10:03:14
START	2017-Jan-05 16:08:31
START	2017-Jan-04 10:47:45
STARTED	2017-Jan-05 12:28:00
STARTED	2017-Jan-04 16:59:50

<tbody>
</tbody><colgroup><col><col></colgroup>



<tbody>
</tbody><colgroup><col><col></colgroup>

 

[oldbrewer]

do you only want to change the date format in certain rows ?

 

[stacey52891]

do you only want to change the date format in certain rows ?

Yes, It will be column B

 

[oldbrewer]

App Status	last_update_time	newdateformat
COMPL	2017-Jan-04 10:03:14	01/04/2017
COMPL	2017-Jan-05 16:49:47	01/05/2017			Count of newdateformat	App Status
COMPLETED	2017-Jan-04 16:59:50	01/04/2017			newdateformat	DENI	PEND	Grand Total
COMPLETED	2017-Jan-05 12:28:00	01/05/2017			01/04/2017		1	1
DENI	2017-Jan-05 00:15:16	01/05/2017			01/05/2017	2	1	3
DENI	2017-Jan-05 00:15:16	01/05/2017			Grand Total	2	2	4
N/A	2017-Jan-04 10:47:45	01/04/2017
N/A	2017-Jan-05 16:08:31	01/05/2017
PEND	2017-Jan-05 16:49:47	01/05/2017
PEND	2017-Jan-04 10:03:14	01/04/2017
START	2017-Jan-05 16:08:31	01/05/2017
START	2017-Jan-04 10:47:45	01/04/2017
STARTED	2017-Jan-05 12:28:00	01/05/2017
STARTED	2017-Jan-04 16:59:50	01/04/2017
					Apr	04
					Aug	08
					Dec	12
					Feb	02
					Jan	01
	note the new column of dates to your format			July	07
	are NOT dates - they are text				Jun	06
					Mar	03
					May	05
	the pivot table has found the 1/4/17 PEND			Nov	11
	and the duplicate entries on rows 6 and 7			Oct	10
	and the pending on 1/5/17				Sep	09

<colgroup><col><col><col><col span="2"><col><col span="2"><col><col></colgroup><tbody>
</tbody>