+ Reply to Thread
Results 1 to 6 of 6

find bold number in Column A and copy range to column C

  1. #1
    Registered User
    Join Date
    11-23-2012
    Location
    Suomi
    MS-Off Ver
    Excel 2003
    Posts
    3

    find bold number in Column A and copy range to column C

    Hi,

    Can someone please help. I'll get once in a month excell sheet and there are about 40.000-60.000 rows.
    there is a number (here and there) witch is bold and after that there are about 3-4 rows and i need
    to copy these rows to own cell. I have a makro which find these all bold number but thats it. i don't
    know what i have to change. i have been trying couple weeks.



    -------->

    Please Login or Register  to view this content.
    <--------

    Can some one please help me!

    br,

    Joek

    ps. sorry my bad english.
    Attached Files Attached Files
    Last edited by joek13; 11-24-2012 at 10:33 AM. Reason: title edit more descriptive

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Question about makro

    Hi, Joek,

    since the definition
    ...there are about 3-4 rows...
    is not very precise, maybe it would be best to attach a workbook with some characteristic datasets and show what data needs to be copied. I for my part canīt figure out by this description what limits the range for the cells to be copied.

    And maybe you change the thread title to something more detailed as requested by the Forum Rules.

    Ciao,
    Holger
    Last edited by HaHoBe; 11-24-2012 at 05:27 AM.
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    11-23-2012
    Location
    Suomi
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Question about makro

    Hi,

    thanks for reply. I attach excel and i hope that helps. I edit title more descriptive. Thanks!

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Question about makro

    Hi, joek13,

    so thread title should be something like find bold number in Column A and copy range to column C?

    Please Login or Register  to view this content.
    Ciao,
    Holger

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Question about makro

    joek13,

    Welcome to the forum.

    I have added code tags to your 1st post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
    Last edited by arlu1201; 11-24-2012 at 11:47 AM.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  6. #6
    Registered User
    Join Date
    11-23-2012
    Location
    Suomi
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Question about makro

    ok, i just change message title. Holger it's working. Thank you very very much!!!

    joek13

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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