Merge cells and in put text or unmerge cells and design with borders and text

[RIZVI]

good day dear friends,

my requirement is mentioned in the attached sheet.
appreciate your assistance plse

best regards to all
rizvi

[RobVerheyden]

Hi Rizvi,

Do you have any more info?

What did you try already?
Do you have any experience in programming in vba or none at all?
What is the eventual goal of the file?
I think you can get a start already by looking around a bit online..

You should be able to add code to the worksheet (via "alt+F11")...
Then you can write a code which checks the value of "I5" each time there's a change in the workbook.

Then depending on the value of I5 you will need to either merge your range or put in the other values.

Kind regards,
Rob

[sintek]

Making use of sheet2 as a helper sheet...

Please Login or Register  to view this content.

[RIZVI]

Hello RobVerheyden,
Thanks for your kind reply. I do play around with VBA/Formulas, not much though... I recorded 2 macros and with the help of a button, achieving what i need.

But seeing SINTEK's coding which works beautifully, I wonder if this coding could be done on same page without going into another?

Many thanks

best wishes to both
Rizvi

[sintek]

So you don't want to use sheet2 as helper...Can always hide the sheet...
If not, Can you still have the info on sheet2 stored somewhere in sheet1 as a template...

[RIZVI]

hi sintek,
the coding should come in the same sheet. cannot use and extra one, unfortunately. but since i recorded 2 macros to this effect, how about calling the macros?
in fact i did in VBA - IF Range(..) = ".." Then, Call Macro1 else call macro2. but this doesn't work as the system is not reading the code. fyi, there are about 4 different codings in the same sheet.

plsd to hear

best wishes to you
rizvi

[sintek]

No I don't understand...Do you not want to make use of Template...

[RIZVI]

yes, i want to make use of a template to get this done. however, template should be in same sheet.

[sintek]

yes, i want to make use of a template to get this done. however, template should be in same sheet.

the upload solves...

[RIZVI]

Great! Thanks, But seems it's done as a copy/paste...

[sintek]

But seems it's done as a copy/paste...

YES...What do you want?????
Does this not solve your initial requirement...

[RIZVI]

hi sintek,
there should not be a duplicate copy in the sheet where you can copy/paste...
best wishes
rizvi

[sintek]

Perhaps someone else can assist as my solution does not work...

[dangelor]

Possibly (placed in the worksheet's code module)...

Please Login or Register  to view this content.

[sintek]

@dangelor...
Correct, could be you are...
If he wanted long way then he could have just recorded a macro...Or specified...

[RIZVI]

Hi Guys,
thank you all, refer to post 4 I have recorded 2 macro's and achieving my requirement for the moment. however I am still trying to fit in sintek's template though.
Thank you dangelor, appreciated very much.
best wishes to all
Rizvi

[RIZVI]

Thank you all, appreciated.
for the moment recorded 2 macros and achieving my requirement with the help of a button. but still trying to work out sintek's template though.
thank you too dandelor

best wishes
rizvi

[sintek]

What are you trying to figure out...The required wording you wanted (The two options) is saved as a template somewhere else... as per your request in sheet1...Depending on your selection, that template is copied to the required location...