I have two worksheets on one workbook currently listed as Sheet1 & Sheet2
I have the same column (which is T) on each sheet which is a date (6/6/2013) value
I would like a VBA script which will look at both sheets to figure out which sheet has the newest create date.
I'm hoping that this will tell me which of the two sheets contains the newest data!
Next I would like the script to name the newer of the worksheets (New Data) and of coruse the other worksheet (Old Data)
Bookmarks