+ Reply to Thread
Results 1 to 9 of 9

Copy data from all sheets in a Master if criteria is met

  1. 01-04-2019, 03:57 AM #1
    Pirvu Vali
    Pirvu Vali is offline
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Copy data from all sheets in a Master if criteria is met

    Hi guys! I have 3 sheets and a sheet Master . In every sheet except Master, if check x in column B, in Column A will be allocated a unique number. If check y in column B, in column A will be allocated x number. 1, .2 etc. All data will be copied in Master. You can to see more in example
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-04-2019, 08:54 AM #2
    SteynfaardtD
    SteynfaardtD is offline
    Forum Contributor
    Join Date
    06-25-2018
    Location
    South-Africa Pretoria
    MS-Off Ver
    2016
    Posts
    143

    Re: Copy data from all sheets in a Master if criteria is met

    Quote Originally Posted by Pirvu Vali View Post
    Hi guys! I have 3 sheets and a sheet Master . In every sheet except Master, if check x in column B, in Column A will be allocated a unique number. If check y in column B, in column A will be allocated x number. 1, .2 etc. All data will be copied in Master. You can to see more in example
    Hi Please See if you can help me on this https://www.excelforum.com/excel-for...ml#post5037619

    It seems like what you did is what i need.
    Reply With QuoteRegister To Reply
  3. 01-06-2019, 03:59 AM #3
    Pirvu Vali
    Pirvu Vali is offline
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Re: Copy data from all sheets in a Master if criteria is met

    some help please?
    Reply With QuoteRegister To Reply
  4. 01-06-2019, 11:05 AM #4
    SteynfaardtD
    SteynfaardtD is offline
    Forum Contributor
    Join Date
    06-25-2018
    Location
    South-Africa Pretoria
    MS-Off Ver
    2016
    Posts
    143

    Re: Copy data from all sheets in a Master if criteria is met

    Can you help me on my post in VBA??
    Reply With QuoteRegister To Reply
  5. 01-06-2019, 12:11 PM #5
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,833

    Re: Copy data from all sheets in a Master if criteria is met

    @Pirvu Vali: Try the attached file. You will notice that all sheets are blank. The macro assumes that you will always start with blank sheets. Cell AA1 in the Master sheet is used as a helper cell to keep track of the number that is placed in column B. You should enter all the data one row at a time in columns C to N first and enter an x or y in column B last. The macro is in the code module for ThisWorkbook.
    Attached Files Attached Files
    Last edited by Mumps1; 01-06-2019 at 12:13 PM.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  6. 01-06-2019, 04:23 PM #6
    SteynfaardtD
    SteynfaardtD is offline
    Forum Contributor
    Join Date
    06-25-2018
    Location
    South-Africa Pretoria
    MS-Off Ver
    2016
    Posts
    143

    Re: Copy data from all sheets in a Master if criteria is met

    sorry but i went through the code and do not understand how to make it work on my file.

    Please see attached sample of what i need, I managed to get my vlookups right, but now i need to do vlookup from sheet 1 to sheet 2 so that i can submit data to right line in sheet 2
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 01-06-2019, 04:56 PM #7
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Copy data from all sheets in a Master if criteria is met

    Quote Originally Posted by SteynfaardtD View Post
    sorry but
    Please start a new thread to ask a new question.

    Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  8. 01-06-2019, 05:16 PM #8
    Pirvu Vali
    Pirvu Vali is offline
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Re: Copy data from all sheets in a Master if criteria is met

    thank you so much. is possible to copy all data after put x, not to put x or y at last?
    Reply With QuoteRegister To Reply
  9. 01-06-2019, 05:22 PM #9
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,833

    Re: Copy data from all sheets in a Master if criteria is met

    I don't quite understand what you mean. The macro copies the rows one at a time as you enter x and y. In this manner, the data in the Master sheet will always be automatically sorted according to the number in column A.
    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. how copy data from more sheets in Master?
    By Pirvu Vali in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2018, 03:26 AM
  2. Copy Data from multiple sheets based on criteria in a column and paste to master log.
    By Jsonic5280 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2016, 03:55 PM
  3. [SOLVED] Match criteria between sheets and copy cell values to existing record in master sheet
    By Hirad001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2015, 04:28 PM
  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 Rows From Two Sheets Into Master Based On Criteria
    By longstrider in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-28-2012, 05:17 PM
  6. Copy rows from master sheet to other sheets based on criteria
    By spikeysas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2011, 04:28 AM
  7. Copy data from master to other sheets
    By mdshotgun in forum Excel General
    Replies: 5
    Last Post: 03-16-2011, 05:23 AM

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