Hi everyone,
Could anyone provide me step-by-step guide or VBA / Macro that order multiple rows according to the reference order?
For example
- Category 'AA1' with its data is currently at row 25 in the input tab, but it should be at row 2 according to the reference order.
- Category '0.0.0.0' with its data is currently at row 40 in the input tab, but it should be at row 3 according to the reference order.
- Category '123.45.6.789' with its data is currently at row 61 in the input tab, but it should be at row 4 according to the reference order.
- and etc.
Please be informed that some of category may not exist in the input sheet. But, it should be appeared at output.
- There is no category 'BB299' to 'BB498' in the input sheets. But these categories (rows) should be appeared at the output sheet.
The last requirement is to fix all columns. In the future, if there is set 1.1. It should be appeared at the last column ('D'). If there is set 1.2 in another input, it should be appeared at the last column. ('E') This is same as row dimension: if there is a new category 'BB499' in another input, it should be appeared at row 501.
Please take a look at the file attached for example of input, reference order and expected output.
Thank you and have a nice day
N.B. # 1 The real data contains more than 20,000 records, but they are sticky confidential.
Bookmarks