Closed Thread
Results 1 to 10 of 10

a macro to copy merge cell and formatting?

  1. #1
    Forum Contributor
    Join Date
    11-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    260

    a macro to copy merge cell and formatting?

    Hi all,

    I wanted to post this under the macro forum but I am getting an error, so I am posting it here.
    Please see the attached .xls : the cells 55 to 60 refers to the same block of data, so I need to merge all the cells
    in these rows 55 to 60 for all the colums , from column M to column AM. I cannot find any other way but doing it manually,
    but hopefully a macro can be created, so that based on the number of initial rows that a new block of data is made of, it will automatically
    merge the cells for each column as described above.

    Please refer also to THIS VIDEO, this is the action that I'd like to get from the macro
    copy log.xlsx
    aaaaa.jpg

    I would be happy to pay for this help, but previously I was suggested not to post anything in the paid forum because it is not much checked.
    Please let me know if the explanation is clear enough, I will be glad to give any further clarificaitons.

    thank you
    Alex

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,192

    Re: a macro to copy merge cell and formatting?

    Quote Originally Posted by cat3appr View Post
    I wanted to post this under the macro forum but I am getting an error
    I have moved it for you. Could you PM me with the details of the error you got?

    I need to merge all the cells
    Everybody here will tell you to avoid merged cells. If you feel you need merged cells, it is usually an indicator of a problem with data layout design.

    I would be happy to pay for this help, but previously I was suggested not to post anything in the paid forum because it is not much checked.
    It is checked, but it is always a good idea to see you can get free help first.

    Someone may be interested in doing this for you but you will need to define how to determine which rows should be merged. It is certainly possible for VBA to merge cells as you demonstrated in your video, but you have to tell us the criteria for selecting them.

    You have been a member for a long time--are you still using Excel 2010? Please make sure your profile is up to date. Excel has changed a lot since then and we want to get you a solution that will work with your version.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    11-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    260

    Re: a macro to copy merge cell and formatting?

    Quote Originally Posted by 6StringJazzer View Post
    I have moved it for you. Could you PM me with the details of the error you got?

    it was a sort of blue screen now is not appearing, so it seems bypassed.

    Quote Originally Posted by 6StringJazzer View Post
    >Everybody here will tell you to avoid merged cells. If you feel you need merged cells, it is usually an indicator of a problem with data layout design.
    It is just as a company log , the way it is setup, we deal with block of data, as I explained, and I need to stick with merged cells as they are given, regardless of personal tastes.

    Quote Originally Posted by 6StringJazzer View Post
    >Someone may be interested in doing this for you but you will need to define how to determine which rows should be merged. It is certainly possible for VBA to merge cells as you demonstrated in your video, but you have to tell us the criteria for selecting them.
    I believed the video was self explanatory, ok I will add more details: each dataset has its own characteristic and they are in fact separated by green thick horizontal lines. In column A
    there is the series NOY_C2_As-Trenched which includes entries in column C : 0425-N000 to 0425-N005, these entries will change all the times, sometimes they will be a single line
    other times they can include dozens. I Will paste these files names in column C, and they will occopy "n" rows. Based on how many rows they will occupy, I will need to merge all the following
    cells in each column... column F from 55 to 60 column G from 55 to 60...... up to column AL from 55 to 60...

    Attachment 879767

    So the macro should refers to the number of entries in column C, and merge the next cells to the right, based on the image and video.


    I am using the latest version of excel, what I have in my profile it's some obsolete data.
    thank you!
    Alex
    Last edited by 6StringJazzer; 09-26-2024 at 08:54 AM. Reason: fixed errors in quote tags

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,836

    Re: a macro to copy merge cell and formatting?

    ... previously I was suggested not to post anything in the paid forum because it is not much checked.
    I don't know who told you this, but it's not quite true (and if it's me you've gleaned this from, then you have misunderstood).

    What IS true is that the number of members with access to the paid section is smaller (because you have to have reached a certain level on the forum to be given access - Guru status).

    And even if you went down that route, not all of the money you paid would go to your helper.

    Most of the time you will get the help you need on the free forum. It's only really if you have a large project that you want someone to do for you as if working to a brief that the paid section is really of any use.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,192

    Re: a macro to copy merge cell and formatting?

    Quote Originally Posted by cat3appr View Post
    I believed the video was self explanatory
    It just shows selecting some cells and merging them, repeating for a few columns. There is no explanation whatsoever for what cells to merge, and there is no audio. I'll review your explanation here and see if it makes more sense.

    I'm not sure what you were trying to attach but the attachment is invalid. Sometimes we have trouble with image attachments. To attach an image, first click Go Advanced or Preview Post under your edit box. Then click in the text to set the cursor to where you want the image to appear, then press the image icon and attach your image.

  6. #6
    Forum Contributor
    Join Date
    11-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    260

    Re: a macro to copy merge cell and formatting?

    thank you 6StringJazzer and AliGW I made this other video, I don't have audio so I wrote the explanation directly on the video, I trust this should be clear now , and the spreadsheet is the one I have attached on my first post.

    aaasssaaaaaaa.jpg


    ps, I don't remember who suggestsed me not to post anything in the paid forum as it is not attended, anyhow, if it can help, I will be glad to move this there.

    Please let me know, thank you!
    Last edited by cat3appr; 09-26-2024 at 10:44 PM.

  7. #7
    Forum Contributor
    Join Date
    11-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    260

    Re: a macro to copy merge cell and formatting?

    Ok I guess this is too complex for the free forum, how can I move this to the paid one?
    thank you!

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,192

    Re: a macro to copy merge cell and formatting?

    Go to Commercial Services and read the FAQ "sticky" at the top of the post list. PM me or post here if you have further questions.

    https://www.excelforum.com/commercial-services/

  9. #9
    Forum Contributor
    Join Date
    11-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    260

    Re: a macro to copy merge cell and formatting?

    Quote Originally Posted by 6StringJazzer View Post
    Go to Commercial Services and read the FAQ "sticky" at the top of the post list. PM me or post here if you have further questions.

    https://www.excelforum.com/commercial-services/

    Thank you, I just created this thread in the Commercial Services

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,836

    Re: a macro to copy merge cell and formatting?

    This thread is now closed in favour of the one in CS. However, just so that you are aware ...

    CS is manned by a smaller sub-set of the membership - Guru status and above - so paying for help will not open this to a wider, more competent pool of helpers.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. merge cell using conditional formatting
    By shakir1401 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-03-2024, 10:19 AM
  2. Need VBA code to copy and paste pivot row at 17 with formatting and merge of column
    By johnmacpro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2016, 10:04 AM
  3. [SOLVED] Macro - Merge cell if same BL and sum and merge same BL
    By ash3angel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2015, 12:59 AM
  4. [SOLVED] Need VBA macro to copy cell contents instead of its formatting
    By Nanimadhu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2014, 08:27 AM
  5. macro to merge values from one column into one cell and retain source formatting.
    By Scott Taylor in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 12-05-2012, 04:41 PM
  6. Using a macro to copy of formatting of an index matched cell
    By myshadeofglory in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2011, 10:26 AM
  7. Cell formatting in Mail Merge
    By Lighthouse in forum Excel General
    Replies: 3
    Last Post: 12-08-2005, 01:20 PM

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