+ Reply to Thread
Results 1 to 7 of 7

How to efficiently merge cells using a macro?

  1. #1
    Registered User
    Join Date
    08-25-2022
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    5

    How to efficiently merge cells using a macro?

    Hi everyone,

    I am trying to develop an index, but in order to make correct calculations and pivot tables, I need to merge some cells. Doing this manually would take a lot of time, therefore I am looking for a more efficient way. I assume a Macro might help me out here, yet I do not really know how to get started.

    A bit of context on the datasheet: The info in cells E until AB was used to calculate the numbers in cells AC, AD, AE and AF. This information was hided as these cells do not need to be merged.

    I am in the need of a macro that:
    - Merges the value in column A when the organization name is identical.
    - Merges the information in columns AC, AD, AE and AF when it refers to the same organization in column A.

    Can somebody help me out? Thank you in advance for the help!!

    Before
    Screenshot 2022-08-25 at 11.29.31.png

    After
    Screenshot 2022-08-25 at 11.48.40.png


    crossposted on mrexcel
    Attached Files Attached Files
    Last edited by Margot Vanlaet; 08-25-2022 at 06:02 AM.

  2. #2
    Registered User
    Join Date
    08-25-2022
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    5

    Re: How to efficiently merge cells using a macro?

    This is what should happen after the calculation, but done by a macro so that I can re-use it on larger filesAttachment 793336

  3. #3
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,367

    Re: How to efficiently merge cells using a macro?

    Do you have some expected outputs? I don't really understand right now.
    I can't open the attachment in post 2. Could you combine that into your first file?

    Also tell that it's crossposted on MrExcel...
    Last edited by JEC.; 08-25-2022 at 05:58 AM.

  4. #4
    Registered User
    Join Date
    08-25-2022
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    5

    Re: How to efficiently merge cells using a macro?

    Done, thank you for the tips

  5. #5
    Registered User
    Join Date
    08-25-2022
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    5

    Re: How to efficiently merge cells using a macro?

    Done, thank you for the tips

  6. #6
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,367

    Re: How to efficiently merge cells using a macro?

    I strongly discourage to use merged cells but here a solution

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    08-25-2022
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    5

    Re: How to efficiently merge cells using a macro?

    Would another method be more sufficient?

+ 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. How to macro multiple lookups on over 500,000 rows of data efficiently?
    By masked_warrior in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-17-2021, 07:42 AM
  2. Optimized macro to run more efficiently
    By Justin2010 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-13-2020, 02:35 AM
  3. Macro to run formulas more efficiently
    By Ale84 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2015, 06:55 PM
  4. [SOLVED] Macro to more efficiently copy/paste every 21 rows
    By Phil_Packer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-23-2013, 03:08 AM
  5. [SOLVED] Can this macro be written more efficiently?
    By alpinesd in forum Excel General
    Replies: 4
    Last Post: 06-16-2012, 02:46 AM
  6. Merge cells data entry automation...can this be done faster/more efficiently?
    By ewmartin51 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2012, 09:18 PM
  7. Help to get Macro operating efficiently
    By mr_teacher in forum Excel General
    Replies: 4
    Last Post: 09-01-2006, 04:13 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