+ Reply to Thread
Results 1 to 20 of 20

If x, autonumber, if y x value .1, x value.2 etc

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

    If x, autonumber, if y x value .1, x value.2 etc

    hy guys,
    I have this code
    Please Login or Register  to view this content.
    If i put "x" in column B from Sheet1, Sheet2, Sheet3 then in column A is allocated a unique number and is copied in sheet Master. Is possible to implement in this code next request :if i put "y" in column B, then in column A is allocated "x" value.1 (x.1,x.2,x.3 etc) ant copy in Master?

    i will give an example in sheet3
    Attached Files Attached Files

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    this is the good attachment
    Attached Files Attached Files

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    It is possible?

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: If x, autonumber, if y x value .1, x value.2 etc

    Would you explain in words exactly what you want to achieve. By that I don't mean describe what your macro is doing, it may not the the most efficient way, I mean explain from first principles.

    All I can see at the moment is that you want a master list which contains all the data from the other sheets which would be a trivial copy and paste macro.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    If i put "x" in column B from Sheet1, Sheet2, Sheet3 then in column A is allocated a unique number and is copied in sheet Master. This make the code. Would i want is : Is possible to implement in this code next request :if i put "y" in column B, then in column A is allocated "x" value.1 (x.1,x.2,x.3 etc) ant copy in Master?

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    some ideas?

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    a little help, please

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    please, i need for work

  9. #9
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: If x, autonumber, if y x value .1, x value.2 etc

    It seems an unnecessarily complicated way of populating a Mother sheet. Unless I'm missing something obvious all the values from the daughter sheets could be copied and pasted to the mother sheet.

    As for entering a y I'd have another section of code which detected the y entry and worked out the highest x number and the highest suffix, incremented the suffix by 1 and entered it into Col A.

    It's not clear to me whether you ever change an existing number or whether you always add one to the bottom of the list.

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    i always add one to the bottom of the list..if you have another solution, is ok

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    no idea? another solution?

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    nobody can't help me?

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    some ideas?

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    https://streamable.com/u47j1

    that is all i want

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    My code has can to define unique for number in all worksheet
    And can define sub number for y

    Step - 1
    'now your duty is convert to workbook_change

    Step - 2
    For copy all worksheet to worksheet master workbook
    You input code to sheet master in events
    Private Sub Worksheet_activate()
    'copy all worksheet
    End sub

    'done
    "ThankyouFor Attention * And Your Help!!"

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    what code?

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    i found the solution to allocate x.1. x.2, but how can to rezise sheet master with y value?

    Please Login or Register  to view this content.

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    why multiply my data in master?
    Attached Files Attached Files

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    some ideas?

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

    Re: If x, autonumber, if y x value .1, x value.2 etc

    i found the solution. i put in master sheet
    Please Login or Register  to view this content.

+ 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. Vba for Autonumber
    By Anto_BT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2016, 08:31 AM
  2. [SOLVED] Autonumber
    By NaomiDawn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2013, 05:48 PM
  3. [SOLVED] Trying to autonumber
    By nonstopcrunchy in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-29-2013, 02:51 PM
  4. [SOLVED] Autonumber
    By nik7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-23-2013, 06:50 PM
  5. UserForm autonumber
    By adeleex in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2011, 09:15 AM
  6. Autonumber
    By jonnygrim in forum Excel General
    Replies: 2
    Last Post: 07-17-2008, 05:22 PM
  7. [SOLVED] autonumber
    By Hardy in forum Excel General
    Replies: 4
    Last Post: 11-24-2005, 01:45 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