+ Reply to Thread
Results 1 to 5 of 5

If B = "x", then A = unique number

  1. #1
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    If B = "x", then A = unique number

    have a workbook with 5 sheets and 1 sheets Master. If in column B from Sheets1,2,3,4,5 check x, then in column A will be allocate a unique number in Master. if this number already is in master, cell.clearcontents. and i need to copy all data from sheets 1,2,3,4,5 (A:Z) to master. I have this codes, but how can to combine them?
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    crossposted: https://www.mrexcel.com/forum/excel-...ter-sheet.html
    Last edited by alansidman; 10-12-2018 at 09:52 AM. Reason: https://www.mrexcel.com/forum/excel-questions/1073919-copy-sheets-master-sheet.html

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: If B = "x", then A = unique number

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

    No further help to be offered, please, until the OP has complied with this request.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Re: If B = "x", then A = unique number

    nobody can help me?

  4. #4
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241
    Maybe like this

    Please Login or Register  to view this content.
    Last edited by alansidman; 10-13-2018 at 11:11 AM.

  5. #5
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Re: If B = "x", then A = unique number

    Untitled.png


    can help me with a file with code?
    Last edited by Pirvu Vali; 10-15-2018 at 04:21 AM.

+ 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. countif to return "x" for unique & "xx" for duplicate values in a column
    By Shruder in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2018, 05:31 PM
  2. [SOLVED] Count "x" ONLY if corresponding item number unique in other column
    By esbencito in forum Excel General
    Replies: 18
    Last Post: 01-09-2018, 05:48 AM
  3. Replies: 0
    Last Post: 11-22-2013, 01:36 PM
  4. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  5. Replies: 1
    Last Post: 07-16-2010, 02:44 AM
  6. [SOLVED] Re: macro for converting number stored as "text" (or preceeded with ') to "number" formatting
    By markx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 07:14 AM
  7. [SOLVED] macro for converting number stored as "text" (or preceeded with ') to "number" formatting
    By markx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2006, 10:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1