Hello, I have a pre-existing code that has been written before my time. I would like to modify it since I am taking over the excel spreadsheet. The way that this all works is very complicated, but what I need to be done should be straight forward in one section of the code.
There are a total of 3 excel spreadsheets that are open. The main spreadsheet has a button that copies all the cells from the other 2 spreadsheets and dumps them into 2 different tabs for proper formatting and analysis.
What I need to add:
Before the cells are selected in one of the spreadsheets I would like the data to be cleaned up a bit.
1. In Column J "Date Made" I would like to have all dates to be changed to the earliest date found. So let's say that column J has 10/22/2019;10/23/2019;10/21/2019; I would like everything to be changed to 10/21/2019 because it is the lowest date.
2. In Column K "WO#" I would like the entire row to be deleted if a number starts with "9". So if row 10 has a number that starts with 9 in Column K, delete row 10.
Section of the code that I think that this needs to be added to from Module 1 (Full code attached):
Please Login or Register to view this content.
Bookmarks