I'm in a situation where I'm pretty sure I could use an Excel macro to do something, I just don't know how to accomplish it. (I think a macro is the right choice because it's not a one-off, it's something I'd have to apply on a regular basis.
However, my goal is slightly more complicated like first merging, renaming to TOTALs and color the cell
is any fastest way , because my excel will be 3000+ rows
I want to go from this:
Capture.PNG
To this:
Captur1e.PNG
Last edited by AV114; 08-04-2018 at 10:43 AM. Reason: correct attachment
Wrong examplefile? Use a pivottable
without pivot how to merge it ? using code any idea
Hi !
Activate the Macro recorder and operate manually : you will get your own code base !
As a reminder, merging cells can be a mess for any future VBA procedure or even some formulas.
And even asking help in such case, you may be asked to un-merge all the merged cells from your worksheet
in order the procedure or any formula can work correctly …
finally got it.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks