abhi_jain80
New Member
Hi folks,
I got the support on vba script from another excel forum in which the code is pulling out the data in new worksheet from two worksheets for the unique transactions on click of the button. Here is the link...https://www.excelforum.com/excel-programming-vba-macros/1349511-new-worksheet-based-on-multiple-worksheets.html#post5523218
It is absolutely working fine except the date format issue...All the dates appeared in the "output" sheet are not in date format, some are in text format while in the "transactions" sheet from where the dates are being pulled are in date format. See the sample file attached (issue highlighted in yellow color). I observed that this issue appears only where there is only 1 transaction.
I spent loads of time on the issue but could not be able to figure out the workaround. Hope I am clear with the requirement. Just wondering if anybody came up with the same issue or aware of any solution. Many thanks in advance...
Abhi
I got the support on vba script from another excel forum in which the code is pulling out the data in new worksheet from two worksheets for the unique transactions on click of the button. Here is the link...https://www.excelforum.com/excel-programming-vba-macros/1349511-new-worksheet-based-on-multiple-worksheets.html#post5523218
It is absolutely working fine except the date format issue...All the dates appeared in the "output" sheet are not in date format, some are in text format while in the "transactions" sheet from where the dates are being pulled are in date format. See the sample file attached (issue highlighted in yellow color). I observed that this issue appears only where there is only 1 transaction.
I spent loads of time on the issue but could not be able to figure out the workaround. Hope I am clear with the requirement. Just wondering if anybody came up with the same issue or aware of any solution. Many thanks in advance...
Abhi