+ Reply to Thread
Results 1 to 4 of 4

for each sheet with first 3 char matching variable, copy column C to Target sheet unless..

  1. #1
    Registered User
    Join Date
    10-14-2011
    Location
    chesapeake, va
    MS-Off Ver
    Excel 2007
    Posts
    59

    for each sheet with first 3 char matching variable, copy column C to Target sheet unless..

    So I've been trying to Copy Column C from Each Sheet that starts with "STU" to Sheet("Target") starting at "A2", there will be other sheets not starting with "STU" but if add additional sheets starting with "STU", I want to enter only the new info to the next blank column stating at row 2.. I'm using the sheet names as the A2 header, then filling in the info under the header, A3.
    I've manage to copy the code, use only the sheets i wanted, but it i ran the code a secong time, it just adds all the sheets again, I've tried using application.worksheetfunction.match, tried coping sheet names first, then check cell values against sheets, but am unable to figure it out..

    here's the code I've butcher, please don't laugh too hard, I'm trying
    Please Login or Register  to view this content.
    there's other code, all under workbook, but it doesn't function
    and heres the workbook
    StuTest V1.xlsm
    Last edited by Spyderz; 11-11-2012 at 02:36 AM.

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: for each sheet with first 3 char matching variable, copy column C to Target sheet unle

    Give this a try. Put into a Standard Module not the worksheets module.

    Please Login or Register  to view this content.
    Last edited by mike7952; 11-10-2012 at 07:50 PM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    19,915

    Re: for each sheet with first 3 char matching variable, copy column C to Target sheet unle

    ..................
    Attached Files Attached Files
    Last edited by jindon; 11-11-2012 at 03:54 AM.

  4. #4
    Registered User
    Join Date
    10-14-2011
    Location
    chesapeake, va
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: for each sheet with first 3 char matching variable, copy column C to Target sheet unle

    Quote Originally Posted by mike7952 View Post
    Give this a try. Put into a Standard Module not the worksheets module.
    Thanks Mike, that worked great, I did added a quick sub to delete blank rows then called the one you posted only because it was static here
    Please Login or Register  to view this content.
    but again thanks for the assistance, I've never used "Like", i think that could solve a great deal of problems i've had in the past.
    thanks again,
    -Daniel

    Marked Post as Solved and added to Rep, Thanks
    Last edited by Spyderz; 11-11-2012 at 02:38 AM. Reason: Marked Post as Solved

  5. #5
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: for each sheet with first 3 char matching variable, copy column C to Target sheet unle

    @Jindon,

    Why would you post Password Protected Workbooks? Makes no sense!

+ 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