Results 1 to 4 of 4

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

Threaded View

  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.

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