1. Get data from Column A, B, C, D, E from worksheet1 and return the data into a new worksheet3 (Combined Columns A, B, C of worksheet1 goes to Column B of worksheet3 in the following format DD-MM-YYYY, Column D of worksheet1 goes to Column C of worksheet3, Column E of worksheet1 goes to Column D of worksheet3)
(Column A has date type (DD), B has date type (MM), C has date type (YYYY), D, E,F have number type ([url removed, login to view]))
2. Get data from Column A and B from worksheet2 and return the data into worksheet3 (Column A goes to Column A of worksheet3, Column B of worksheet2 goes to Column F of worksheet3 (Column A has Date type (DD-MM-YY), B has number type ([url removed, login to view]))
* Date from Column B must match the date from Column A if not leave a blank cell in Column B, C, D and E until they are matched.
** Instead of combing Columns A, B, C of worksheet1 as DD, MM, YYYY sometimes I may only have one column A as DD-MM-YYY.