joeny0706
11-17-2019, 05:04 PM
I have an excel file that I receive daily. I have a column with a date that I need to be changed to the day before and then that column copied to another. I have been looking how but no luck yet.
I already have two VBA modules I run on it to change theproducts and names to match my format. But now I need a module to change dateand copy column so I don’t have to manually do it each time.
Anyone want to help or point me in the direction to complete this task.
I have attached two files. One is the before and the second it what I am tryingto convert it to
The date in column E is 11/19/2019. I need that changedto 11/18/2019. I will always need to changed to the day before the one that islisted. If it says 11/25/2019 I will need it changed to 11/24/2019. I then need column E after the date is changed copied to column I.
Is that something that is possible to do. Right now I just do a replace and copy and paste. If I could have a VBA code that does it would be great and save me a lot of time.
Thanks All
I already have two VBA modules I run on it to change theproducts and names to match my format. But now I need a module to change dateand copy column so I don’t have to manually do it each time.
Anyone want to help or point me in the direction to complete this task.
I have attached two files. One is the before and the second it what I am tryingto convert it to
The date in column E is 11/19/2019. I need that changedto 11/18/2019. I will always need to changed to the day before the one that islisted. If it says 11/25/2019 I will need it changed to 11/24/2019. I then need column E after the date is changed copied to column I.
Is that something that is possible to do. Right now I just do a replace and copy and paste. If I could have a VBA code that does it would be great and save me a lot of time.
Thanks All