Conditional Cell Location

[Parsnips]

Is it possible to change a cell location based on the value of another cell?
I want the formula/content of B1 to move to B2. I am creating a calender, and I want to be able to change the date of an event in one column, and have the corresponding contents of a cell move on the calender to reflect the change. Thanks in advance.

 

[AD_Taylor]

Well it is possible to move the cells formula information with a macro/VBA code but I would approach this a different way.

You could set up a list of all the events and then on the calendar view just use a VLOOKUP to this list that pulls out the relevant information?

Happy to send an example spreadhseet by e-mail if you like (and give me a couple of days )

 

[Parsnips]

Thanks, the problem is is that I want to be moving merged cells with data in them, and the VLookup won't work for that.