I need to arrange data from a master sheet with the original data into other sheets within the same workbook. However, there are separate sheets defining the product types.
With reference to the attached sample, the master sheet is refreshed on a regular basis to download new data from an external database.
Everytime the master sheet is refreshed, I would need to sort out "Land" and "Flats" into the appropriate worksheets, and transfer the corresponding columns of data into the sheets. The columns are also in a different order from the master sheet.
I tried using a Pivot table, but the actual data may contain some blanks, which makes sorting difficult, and it use up memory space too.
Are there more simple ways to automate this data arrangement?
Thank you in advance for advises.
Pingpong
Bookmarks