Results 1 to 19 of 19

Thread: Merging multiple worksheets into one

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,709
    Location
    So you have a bunch of CSV Files, The Primary key is the first Field. "Regno Number"
    You have a Class Ref (Somewhere)
    You have a Workbook somewhere that has a Sheet2 with some data.
    You have a file of some sort called "extract_class."

    Have I got that right so far?

    • Where does Class Ref come from?
    • How does does Field 3 (from Sheet2) get in there.
    • When some records are "Merged with field Above" What operations are done? Are some added, subtracted, Min'ed, Max'ed, what?
    • How does the "extract class" file fit in?


    It is pretty easy to read all CSV files in a folder and Filter them on one or more Keys, but it's those unknowns that count.
    The is in the details

    Don't worry, we go thru this discovery process a lot. We don't have expertise in your Domain and you don't speak our lingo.
    Last edited by SamT; 01-13-2016 at 03:20 PM.
    Please take the time to read the Forum FAQ

Posting Permissions

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