Attached here are 2 excel files: "A" is the starting point. In "B", some of the processing has already been done to the data. I am trying to get this processing done using a macro.
A.xlsx
B.xlsx
If you open "A", there are 2 tabs: "Raw Data" and "Organized Data". In the tab "Raw Data", first column (which is named "Text"), this column contains long strings of text which are unique for each different day in the calendar.
What I am doing now is tedious: I will put a filter on all the data in tab "Raw Data", and single out a unique set of text under the column "Text". for example, I will filter to show only rows that show "210020120901CAD" in the first column. I select all the filtered data by highlighting and dragging down entire rows, copy, and then go to the next tab named "Organized Data"
In the "Organized Data" tab, I right-click to select the entire row immediately below the top most date (dates are in the left most column) which has an empty row below it. I then 'insert copied cells' here. I have already added formulas that calculate the subtotals automatically after you insert the cut cells.
If you open file "B", This is what I would like to achieve in the tab "Organized Data".
**It doesn't matter if the values in "Text" column from the tab "Raw Data", do not match the dates in the tab "Organized Data". Just as long as under each "Date" in tab "Organized Data", there is a unique value for the first column, as shown in the excel file "B"
Sorry for the long post and the super tedious task ( appreciate all your help
Bookmarks