Hi
I have two cells. A1 contains the label "Total Sales" and B1 contains the value, e.g. "£123,456".
I want these cells to populate a textbox in the same sheet so that the value is bold and on a new line. Something like...
What formula do I need to attach to the text box for this? Naturally if the Total Sales value changes, I want the text box to automatically update.
Can anyone help?
thanks
Richie
I have two cells. A1 contains the label "Total Sales" and B1 contains the value, e.g. "£123,456".
I want these cells to populate a textbox in the same sheet so that the value is bold and on a new line. Something like...
What formula do I need to attach to the text box for this? Naturally if the Total Sales value changes, I want the text box to automatically update.
Can anyone help?
thanks
Richie