+ Reply to Thread
Results 1 to 14 of 14

Automatically copying a data into another worksheet in same workbook

  1. #1
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Automatically copying a data into another worksheet in same workbook

    Hi,

    I have prepared an excel file where I am stuck a little bit. I am having an idea but I just cant implement it. I have attached the excel file and il now share my idea.

    I want a macro in the excel file to seggregate all the vessels into other worksheets in the same workbook. For Ex: First vessel name is = Maersk Dabou. So i need another sheet to be automatically named "Maersk Dabou". and automatically create an hyperlink in the errors column. For Ex: A16 should be an hyperlink cell and by clicking it i should go directly to that sheet.

    I have many files such way. So i need a macro which would segregate it that way. I hope am clear. Kindly reply if not.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Automatically copying a data into another worksheet in same workbook

    hi Raju Radhakrishnan, please check attachment, run code "test". I do not see requirement to copy data for each unique vessel but I added it to the code. If you do not need it it can be easily deleted.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Automatically copying a data into another worksheet in same workbook

    Superb..I needed this because these data are not lesss...these are heavy things...Dear can you modify it...I need only worksheet names....Inside every worksheet I need Headings: - 1) Errors 2) Error type 3) BA

  4. #4
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Automatically copying a data into another worksheet in same workbook

    Dear just a correction..I need these headings:
    1) Vessel Code 2) Vessel Name 3) Voyage 4) Port 5) Operator 6) Tp -Doc number 7) Error Type 8) BA

  5. #5
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Automatically copying a data into another worksheet in same workbook

    And also what I have found is its not creating 2 separate worksheets which has same vessel name I need everything!! For ex: If there are 2 times Vessel ABC...I need the worksheet names as Vessel ABC 1 and Vessel ABC 2.....

  6. #6
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Automatically copying a data into another worksheet in same workbook

    please check attachment, run code "test"
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Automatically copying a data into another worksheet in same workbook

    Yes this is according to the plan for sure but can you please add the hyperlink in the column errors in sheet 1 where we run the macro....so that my users could navigate it easily! sorry for the trouble! n ya you are awesome..thanks

  8. #8
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Automatically copying a data into another worksheet in same workbook

    please check attachment, hyperlinks have been added
    Attached Files Attached Files
    Last edited by watersev; 05-19-2012 at 12:02 PM.

  9. #9
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Automatically copying a data into another worksheet in same workbook

    Superb...as I wanted...Thanks a lot...

  10. #10
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Automatically copying a data into another worksheet in same workbook

    Hey one more thing I wanted to add in this macro....Is it possible that rows in which theres no data/green colored rows - theres no need to prepare a new worksheet for those rows as there wont be any errors in it!! Can we change the macro ?? Thanks in advance

  11. #11
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Automatically copying a data into another worksheet in same workbook

    please check attachment
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Automatically copying a data into another worksheet in same workbook

    Bro...I think you got me wrong...This excel is preparing worksheets only for green colored rows...I want it the other way...I dont want to prepare worksheets which is green in color...(Which has no data) & also no need to prepare the worksheet where Complete transshipment is written in status column...

  13. #13
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Automatically copying a data into another worksheet in same workbook

    change this:

    Please Login or Register  to view this content.
    to this

    Please Login or Register  to view this content.

  14. #14
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Automatically copying a data into another worksheet in same workbook

    Superb...Its working...Thanks...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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