+ Reply to Thread
Results 1 to 4 of 4

Loop through column in first sheet, match value with sheet names in workbook, copy/paste.

  1. #1
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Loop through column in first sheet, match value with sheet names in workbook, copy/paste.

    I have one Workbook.

    First sheet is named "Main Sheet", second sheet is named "Summary", all sheets after have specific names (different Themes).

    On "Main Sheet" user will be inputting data in categories eg. in 5 columns ("A:E"). All the other sheets will have same columns.

    On "Main Sheet" I'm working on a button that will loop through column eg. "C" (Themes), match it with sheet name, and copy the row from "Main Sheet" and paste it after the last input in the sheet with the same name (Themes).

    At the same time after the user will finish the input in the "Main Sheet", button should copy/paste all the inputs to "Summary" sheet (paste after the last input in "Summary" sheet) and delete inputs in "Main Sheet".

    I have attached workbook for better understanding.

    Thank you.
    Attached Files Attached Files
    Last edited by Tona; 11-05-2014 at 07:41 AM.

  2. #2
    Registered User
    Join Date
    10-26-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007 & 10
    Posts
    19

    Re: Loop through column in first sheet, match value with sheet names in workbook, copy/pas

    Hi Tona,

    Please Login or Register  to view this content.
    Paste this in the button --> Assign Macro --> new
    Hope it will help you

    Enjoy....
    Regards,
    Balaji M

  3. #3
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Re: Loop through column in first sheet, match value with sheet names in workbook, copy/pas

    It did!
    Will learn the code and modify for my needs.
    I appreciate it!

  4. #4
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Re: Loop through column in first sheet, match value with sheet names in workbook, copy/pas

    Having some troubles with existing macro, causes "excel not responding" and takes quite a long time.

    Any suggestions for modifying?

    Thank you.

+ 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: 2
    Last Post: 01-22-2014, 05:36 PM
  2. Replies: 1
    Last Post: 01-08-2013, 03:38 AM
  3. Replies: 7
    Last Post: 12-03-2012, 03:10 AM
  4. Replies: 0
    Last Post: 05-24-2010, 05:17 PM
  5. Match column from sheet 2 to sheet 1 and copy rows if match exists.
    By GravityInvert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2008, 01:42 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