Results 1 to 4 of 4

Table to List for large data set using Macro

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2017
    Location
    DC
    MS-Off Ver
    M365. Will specfiy in post if 2010
    Posts
    5

    Table to List for large data set using Macro

    Workbook has two worksheets. Have & Desired. The datasets are circa 50,000 rows with a variable amount of MMM-YY columns.

    Tried Kutools with no luck.

    Not enough VBA knowledge to edit a script like this one:
    https://www.extendoffice.com/documen...e-to-list.html

    Posted in this form to see if there was a non-macro / VBA solution. Any pointers appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clear List Macro for Data Validation, Multiple Lines in table
    By gedwards913 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2014, 04:42 PM
  2. create dynamic drop down list for large list of data
    By Dariusd7 in forum Excel General
    Replies: 2
    Last Post: 05-10-2014, 04:39 AM
  3. Replies: 0
    Last Post: 01-23-2013, 07:57 PM
  4. [SOLVED] Macro to list data from a table and sort it alphabetically
    By Siglen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2012, 11:06 AM
  5. Replies: 3
    Last Post: 09-12-2010, 07:56 AM
  6. Creating a list from a large table
    By davidmarlow in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-23-2009, 05:37 AM
  7. Macro to create pivot table from large data file
    By johnson748r in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2007, 02:36 PM

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