a macro to copy merge cell and formatting?

Originally Posted by cat3appr

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.

Originally Posted by 6StringJazzer

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.

Originally Posted by 6StringJazzer

>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.

Originally Posted by 6StringJazzer

>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

... 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.

Originally Posted by cat3appr

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.

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!

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/

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.