+ Reply to Thread
Results 1 to 10 of 10

Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

  1. 09-13-2014, 06:54 PM #1
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    Hi

    I try copy multiples Sheets to one sheet based one criteria in column "J" <- this criteria is formula (MyStrinIsFormula)

    Please Login or Register  to view this content.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
    Reply With QuoteRegister To Reply
  2. 09-13-2014, 07:05 PM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    What is the problem?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 09-13-2014, 07:09 PM #3
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    Use one of these lines

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 09-13-2014, 07:16 PM #4
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    Hi

    if different "Master" then copy all contents in all sheets, but copy only value in cell (columns J), equal "expired products" this string insert by formula, look my file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 09-13-2014, 07:20 PM #5
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    marreco,
    You do not have "MyStrinIsFormula" in all sheets, let alone column J
    What is "MyStrinIsFormula"?

    This one works

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 09-13-2014, 07:23 PM #6
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    Hi AB33
    What is "MyStrinIsFormula"?
    result formula in cell, look my file please, thank you!!!
    Reply With QuoteRegister To Reply
  7. 09-13-2014, 07:25 PM #7
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    Did you try the code on post no 5 ?
    Reply With QuoteRegister To Reply
  8. 09-13-2014, 07:29 PM #8
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    Hi AB33, your code work very well, thank you!!

    But....i want more one question.

    So i want cut this criteria (based Column J) each sheet <> "Master", how i can it?
    Reply With QuoteRegister To Reply
  9. 09-13-2014, 07:44 PM #9
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    Try the attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 09-13-2014, 08:36 PM #10
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Copy Multiples Sheets to One Sheet by Criteria in Column (in All sheets)

    Hi AB33, very perfect!!

    Thank you very much!!!
    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. Code to copy a row from multiple sheets to a summary sheet per criteria
    By rmwindham in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-29-2014, 11:05 AM
  2. Autolist of code in one sheet from multiples sheets in excel
    By NILESH ZALA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2013, 08:52 AM
  3. [SOLVED] Copy data from column to other sheets, based upon vlookup/criteria on column a
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-27-2013, 04:01 AM
  4. Copy data from master sheet to other sheets if criteria is met.
    By teachaman in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-30-2012, 06:43 AM
  5. Copy all row's of data across all sheets, that meet certain criteria, to one sheet.
    By r0bd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2012, 01:21 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1