+ Reply to Thread
Results 1 to 4 of 4

Concatenate Data form various sheets into single sheet

  1. #1
    Registered User
    Join Date
    07-20-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    43

    Concatenate Data form various sheets into single sheet

    I have code that I can point at a folder full of Some.csv files - it will open them for processing and then close them, that all works good.

    What I need is to copy the contents of each *.csv file into one single sheet - all the data pasted directly underneath the last on the master sheet.

    I think all my sheets will have the same number of columns but... I would like to make the process dydnamic so that th copy part of the operation can copy the data no matter whether it all has the same number of columns or not (so it might end up with a 'ragged' right hand edge).

    I am having trouble with the copy part - I seem to need to be able to define a Range that will be used in the copy, but that requires that I have 'Alpha' references for the number of columns like - pseudo code;
    Please Login or Register  to view this content.
    I can get the number of rows and columns saved to variables, but how do I use those to specify the copy target and the paste starting cell ?

    I may be approaching this the wrong way and could do with some help as I have written about a thousand lines of code in ever more complicated ways.. none of which work yet !

    Thanks for any help

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Concatenate Data form various sheets into single sheet

    Does this help?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-20-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Concatenate Data form various sheets into single sheet

    Thanks for the help John.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Concatenate Data form various sheets into single sheet

    You're welcome. Glad to help out and thanks for the feedback. If that resolves this issue please mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 10-12-2015, 10:02 AM
  2. How to Add Data of Different sheets in a single sheet
    By mfhaq77 in forum Excel General
    Replies: 2
    Last Post: 05-10-2015, 06:52 PM
  3. Concatenate 2 sheets data into one sheet
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2014, 09:42 AM
  4. extract data from 2 sheets to single sheet
    By sumonrezadu in forum Excel General
    Replies: 3
    Last Post: 01-31-2014, 10:26 AM
  5. Combine data from different sheets into a single sheet
    By cndesu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-28-2012, 08:25 PM
  6. Replies: 1
    Last Post: 08-24-2012, 05:52 AM
  7. [SOLVED] Multiple sheets as data for a single sheet
    By Newbie1092 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-19-2005, 01:25 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