Linking only BOLD text between worksheets

[p3te2]

Hi there,

Im trying to set up a link between 2 cells of different worksheets.

In the first worksheet, i have an open points list which contains multiple sentences/entries in each cell. I normally format the last sentence/entry of each cell in BOLD .

In the second worksheet, i have a meeting minutes template which has empty cells which i would like to be linked to the bold text only (emitting the previous non-bold sentences_) from the cells in the first worksheet.

Is this possible with a simple formula or do I need to create a macro of some sort?

I hope it's not too confusing what I've written above and thanks very much in advance for any help!

regards,
Peter

[rwgrietveld]

You could go into enourmous trouble, using VBA and such, but why not add a simple CheckBox and put your filter criteria on that?

[p3te2]

Hi rwgrietveld,

Thanks for the tip! I've not really worked with checkboxes before.....I've just had a quick attempt at creating one with a link to a cell but that's as far as I got. How do I apply a 'bold' filter?

Sorry if it's actually an obvious fix!