+ Reply to Thread
Results 1 to 3 of 3

Auto Sort of Data

  1. #1
    Registered User
    Join Date
    02-24-2007
    Posts
    84

    Auto Sort of Data

    As you can see from the attached spreadsheet. I have a page called Pattern Etch where we enter the data for all the processing done in a single machine.
    Each device type is slightly different, and therefore has a different calculation fasctor for its etch time.

    This all weorks fine.

    What I had previously was another spreadsheet with the pages b and g in it. This is where the factors are calculated and updated from.

    I'd like to make this update automatic, and suspect the easiest way is to combine the two spreadsheets, as in the attached version.

    Can the sorting of the data from the patternetch page to the apprpriate pages, b and g be done automatically?

    If so can it be done for many pages as I have cut down the spreadsheet, I actually have 50 variants, each will need its own page (as for b and g).

    Hope thats not too confusing......the spreadsheet should make it clearer.

    Any help greatly appreciated.

    Thanks,
    Gavin.
    Attached Files Attached Files
    Last edited by gavster; 04-07-2009 at 08:35 AM.

  2. #2
    Registered User
    Join Date
    02-24-2007
    Posts
    84

    Red face Re: Auto Sort of Data

    It occured to me last night that I could add a button with an attached macro to sort the data by the device type column.

    However, I'm not sure how to then copy and save the appropriate columns to the other worksheets, without copying all the data.

    Any suggestions!!

    Thanks,
    Gavin.

  3. #3
    Registered User
    Join Date
    02-24-2007
    Posts
    84

    Re: Auto Sort of Data

    I've now sorted this problem.

    Onto the next..

    Thanks,
    Gavin.

+ 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