I have a range of data that has a header name. on the left of this range is a hidden column that is combining two cells into one cell name.( name and date). An example of this would be the name in cell b1 and the date in b3.($B$1&"-"&$B$3)
I wish to copy this range of data down multiple times and with each copy change the name used as the header. The dates however will never change.
what I would like is a macro of formula that will automatically recognize the new name cell and change the left formula to display the date and the new name.
I have provided a working model to work with.
https://app.box.com/s/q4mkmw4cnxyv7pwb4rtgt6fqptnk4qlq
I wish to copy this range of data down multiple times and with each copy change the name used as the header. The dates however will never change.
what I would like is a macro of formula that will automatically recognize the new name cell and change the left formula to display the date and the new name.
I have provided a working model to work with.
https://app.box.com/s/q4mkmw4cnxyv7pwb4rtgt6fqptnk4qlq
