What I'm trying to do is I have for example a row that contains information about my software. And in 4 of those cells there are sentences that include the version #. Right now when I want to update the version number from 2015.09.19.1950 to say 2015.09.19.2110 I have to manually go to each cell that contains the sentence where the version # is included.
What I want to do is have a column called 'Versions' and when I change the version in that single column it will update the version number within the sentences in each cell I tag within that row.
So example. The new version was 2015.09.19.2110
And in one of my columns call [version] within the cell the words would be:
MySoftwareName :: Version - 2015.09.19.2110
In another column(many columns per row) called [short_description] within that cell are these words and the version should change automatically when I key it into the 'Versions' column...
This is the short description of MySoftware and its current version is 2015.09.19.2110, to download click here
I can go on, but there are 4 columns where I need to tag within each of the cells sentence of wording that this is the 'version#' that will change automatically when I key it in the version column. So I key it once and it populates it into the text sentences I have tagged for it to be in sync.
Thank you deeply for anyone who has experienced this before and can share the how-to :D