I'm attaching excel workbook with this thread.
in this workbook sheet named as ORIGINAL is System Generated file without any editing.
second sheet is named as PASTE MTR which is edited System Generated file in which I have removed all blank space.
and Third sheet is named as MTR IN - OUT which is the Output table format I want after running VBA code.
earlier, I have posted the thread to get the help for the same issue and one user provided the solution but there was a date format issue. in my System generated data, Date format is in "DD-MMM-YY" but after running VBA code date format changes to "MM-DD-YY" which can create mess in my work. and if you can go further one step and change system generate date in output file "DD-MMM-YYYY" it will be very good. link of this thread is given below
excelforum.com/excel-programming-vba-macros/1312089-need-help-to-generate-desired-data-in-new-excel-sheet.html
also in above thread I provided only PAST MTR sheet not System Generated file, but If you can provide the VBA code to generate the data direct from System Generated file it will be very helpful.
In this attached workbook I have made two changes in my user expected file.
First is Bifurcation of the column "Transaction Quantity
" with Positive and Negative quantities.
Second is I have added column at the end with name "Report Generated Date & Time
" in which Date and Time should be of VBA code running Date and Time. and this Date and Time format should be of "DD-MMM-YYYY HH:MM AM/PM"
Bookmarks