+ Reply to Thread
Results 1 to 3 of 3

Macro to match cell value to worksheet name and copy all rows and row data

  1. 10-28-2013, 07:25 AM #1
    jamesmcgallan
    jamesmcgallan is offline
    Registered User
    Join Date
    10-25-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    7

    Question Macro to match cell value to worksheet name and copy all rows and row data

    Hi, this is my 1st posting, i'm a beginner with vba and have got as far as i can with the problem I've got

    I'm using Excel 2010

    I have a "Data" sheet which holds all information for orders, I have a macro that looks through the sheet and creates a new worksheet based on the Id's in column A.

    What i now need is a Macro to

    1 - Copy the column titles to all created sheets
    2 - Match the ID in column A to the sheet names and copy the matching rows from "Data" into the sheets with the same name.

    this is what i have so far (also attached), thanks in advance.

    Please Login or Register  to view this content.
    inventory example1.xlsm
    Last edited by Fotis1991; 10-28-2013 at 09:02 AM. Reason: pls use code tags around your codes as per forum rules.
    Reply With QuoteRegister To Reply
  2. 10-28-2013, 08:32 AM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to match cell value to worksheet name and copy all rows and row data

    James,
    Welcome to the forum!

    Please read forum's rule regarding code tags.
    Try the attached.
    Attached Files Attached Files
    Last edited by AB33; 10-28-2013 at 08:46 AM.
    Reply With QuoteRegister To Reply
  3. 10-28-2013, 09:21 AM #3
    jamesmcgallan
    jamesmcgallan is offline
    Registered User
    Join Date
    10-25-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Macro to match cell value to worksheet name and copy all rows and row data

    Many thanks, that works great.

    Apologies for the lack of code tags, will make sure they are in my next post.

    thanks again
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro copy data range from individual worksheets to new rows in consolidated worksheet
    By bushpotato in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 01:24 AM
  2. [SOLVED] Macro to match cell value on two wooksheet copy data on another column on row back to 1st
    By JDC_8 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2013, 08:39 PM
  3. [SOLVED] Macro to copy data rows to a summary worksheet if the row satisfies a condition
    By cjfreeseman in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-05-2012, 03:33 AM
  4. [SOLVED] Copy rows from my main worksheet to another worksheet based on data in one cell
    By gcol in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-08-2012, 05:12 AM
  5. Need macro to find data rows and copy to another worksheet.
    By n2lectual in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2009, 04:07 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1