Hi all,
New member here so apologies if this has been answered already, but I believe it is a pretty niche request. I've seen videos and articles relating to automatically creating comments based on other cells, but I need this to work based on an indexing in another sheet.
I've attached a link to an example spreadsheet which should hopefully explain what I'm looking to achieve. To give a bit of background, I've created a way of inputting individual 'builds' in the 'Jobs' sheet and they should then appear on the 'Gantt' sheet next to that Designer's name. What I'd ideally like to see is the contents of the corresponding cell in column D on 'Jobs' appear as a comment in the last relevant cell on the 'Gantt' chart.
I'm completely green when it comes to coding, so would appreciate any help with this. Hopefully it's not too difficult, but if it is, I hope it comes as a welcome challenge to someone!
Link to spreadsheet
New member here so apologies if this has been answered already, but I believe it is a pretty niche request. I've seen videos and articles relating to automatically creating comments based on other cells, but I need this to work based on an indexing in another sheet.
I've attached a link to an example spreadsheet which should hopefully explain what I'm looking to achieve. To give a bit of background, I've created a way of inputting individual 'builds' in the 'Jobs' sheet and they should then appear on the 'Gantt' sheet next to that Designer's name. What I'd ideally like to see is the contents of the corresponding cell in column D on 'Jobs' appear as a comment in the last relevant cell on the 'Gantt' chart.
I'm completely green when it comes to coding, so would appreciate any help with this. Hopefully it's not too difficult, but if it is, I hope it comes as a welcome challenge to someone!
Link to spreadsheet