Good afternoon,

I am looking for a way to merge 4 cells depending on a cell value. I will explain. I am creating a spreadsheet where I will be keeping track of peoples payments for a class. They can pay either weekly or monthly. for example:

If A1 says "Monthly" I want B1:E1 to merge into one cell. If A1 says "Weekly" i want B1:E1 to be 4 separate cells. I am expecting this to be in vba and have a little experience but need a point in the right direction...


Thank you in advance.

Chris