Total Columns may be more
Sheet (One)
Trim Below Column (Col A)
Delete Suffix from Col A.. i.e... Delete last 7 digits or alphanumeric value or numeric or Alphabets.
Ex= 2015-10-08-10.42.15.ABCHDG should be 2015-10-08-10.42.15
Replace Dots from Col A to Colon (
Ex= 2015-10-08-10.42.15 Should be 2015-10-08-10:42:15
Replace last (-) with Space from right of cell
Ex= Ex= 2015-10-08-10:42:15 Should be 10/8/2015 10:42:15 AM
Sheet(Fruit Sheet)
Have Fruit Names, on the basis of these fruits the data should be pulled in Final Sheet
Sheet (Final)
Data in Final sheet will be as per Fruit Sheet...
i.e. Fruit Sheet have Fruit Names so on Double click on any cell in Fruit Name the corresponding data should be filtered & Sorted & pasted in Final sheet.
ON the Selection of other Fruit Name the data in Final sheet should be deleted first & then the above process should be worked on.
Highlight Col A if there is a difference of the timing.. More than One hour gap between col A value & System datetime.
Any Assistance
Bookmarks