+ Reply to Thread
Results 1 to 2 of 2

Arranging Data into different sheets

  1. #1
    Registered User
    Join Date
    11-19-2008
    Location
    Singapore
    Posts
    1

    Arranging Data into different sheets

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848
    The following assumes you already have the Land and Flat tabs created. The macro will copy the information from the first sheet into the appropriate sheet based on the value in the "Product" column. The data is copied to the first blank row on the Land or Flat sheet.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1