+ Reply to Thread
Results 1 to 3 of 3

WO Creation List

  1. #1
    Registered User
    Join Date
    08-27-2010
    Location
    East Anglia
    MS-Off Ver
    Excel 2007
    Posts
    40

    WO Creation List

    Hi All.
    I have a table of data that I'm looking to create a list from, it needs to be as shown on excel sheet.

    PLEASE HELP!!
    Attached Files Attached Files

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,826

    Re: WO Creation List

    Hi Tim, please test the following macro against your sample workbook. Some of the ranges are hard coded, but could be adjusted to allow for larger data tables (or positioned elsewhere) if necessary.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-27-2010
    Location
    East Anglia
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: WO Creation List

    That's awesome mate,
    Is there any way of doing it without macros?

+ 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